How do I enable OData in Excel?

Procedure

Launch Excel, open a blank workbook, and navigate to the Power Query tab.
Select From Other Sources > From OData Feed.
Click OK.
Select the BoilerInterpolations collection.
Review the data that is displayed in Power Query.
Change the sample period to 15 minutes.
Select Done.

How do I change the authentication in Excel?

In the Edit Permissions dialog box, under Credentials, select Edit. Change the credentials to the type required by the website, select Save, and then select OK.

How do I link data feeds in Excel?

Importing data feeds in Excel 2016 using the connection wizard

Select OData Feed as the data source.
Enter the Data Feed URI.
Enter Igloo Authentication credentials.
Select the desired tables.
Edit the selected tables.
Save your Queries (optional)
Load the selected tables.

How do I connect to OData?

Click on OData in the Web/File section….Connect Your Report Template to an OData Service

Enter a Name for your data source connection.
Enter the URI root to your OData service in the Server Address field.
(Optional) Choose your Authentication Protocol.
(Optional) Choose the OData data source version.

How do I clear credentials in Excel?

Click Credential Manager. In the Windows Credentials and Generic Credentials section, remove all stored credentials referencing the Office 365 or Microsoft Office: Select the Credential. Click Remove.

Is Power Query part of Excel 2016?

You’ll find Power Query in Excel 2016 hidden on the Data tab, in the Get & Transform group. In Excel 2016, the Power Query commands are found in the Get & Transform group on the Data tab. If you’re working with Excel 2010 or Excel 2013, you need to explicitly download and install the Power Query add-in.

How do I enable Power Query in Excel 2016?

If you are using Excel 2016, go to the Data tab on the ribbon and press the New Query button to create a query and open the Power Query editor. Power Query is available with all levels of Office 365 subscriptions.