Adding an OData feed power query to Microsoft Excel

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

Steps

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

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

1. Within Excel, select the Data tab.
2. Click on the Get Data button, then select From Other Sources, then From OData Feed.

   Note that on some version Excel, the Get Data button is called New Query instead.

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 working with a single ODataLink account).

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

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

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

7. Click OK to save the login details.
8. In the next dialogue, select the endpoint to retrieve.

   If wanting to retrieve multiple endpoints at once, tick the Select multiple items checkbox and tick two or more endpoints.

9. Click the Load button.

   Selecting multiple endpoints will add one Power Query and OData Feed per endpoint selected.

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

Related Topic

Integrating ODataLink with Microsoft Excel