Adding an OData feed power query to Microsoft Power BI

The following guide will assist in adding an OData feed power query to Microsoft Excel.

Steps

Enter the OData feed url

Enter the login details

Select the endpoint

To add a new add an OData feed power query to Microsoft Power BI, follow these steps.

Before beginning, ensure you have copied the OData Feed URL.

1. Within Microsoft Power BI desktop, select the Home tab.
2. Click on the Get Data button, then OData Feed.
3. Paste the OData Feed URL copied previously and click OK.
4. In the next dialogue, select from Anonymous or Basic matching the Login Type setup for the model.
5. If choosing Basic, additionally enter your username and password used to login to OdataLink.
6. In the dropdown, choose the fist or second entry.

   The first entry will apply the login approach to all of OdataLink. (Recommend for those with a single account).

   The second entry will apply the login approach to the account. (Recommend for those with multiple accounts).

   The third entry will apply the login approach to the model.

   The fourth entry will apply the login approach to the model and data file combination.

7. Click Connect to save the login details.
8. In the next dialogue, tick the endpoints to retrieve and click the Load button.

Once created, you can edit the data using Power Query.

Related Topic

Integrating OdataLink with Microsoft Power BI