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.

Related Topic

Integrating ODataLink with Microsoft Excel