Connect to an OData feed (Power Query)

Use Excel's Get & Transform (Power Query) experience to connect to an OData Feed.

Click on the Data tab, then Get Data > From Other Sources > From OData Feed. If you don't see the Get Data button, then click New Query > From Other Sources > From OData Feed.

In the Power Query ribbon tab, select From Other Source > From OData Feed.

Power Query get data from Other Sources dialog

Next

  1. In the OData Feed dialog box, enter the URL for an OData feed.

  2. Select OK.

  3. If the OData feed requires user credentials, in the Access an OData feed dialog box:

    1. Select Windows if the OData feed requires Windows Authentication.

    2. Select Basic if the OData feed requires your username and password.

    3. Select Marketplace key if the OData feed requires a Marketplace account key. You can select the Get your Marketplace Account Key to subscribe to Microsoft Azure marketplace OData feeds. You can also Sign up for Microsoft Azure Marketplace from the Access an OData Feed dialog box.

    4. Click Organizational account if the OData feed requires federated access credentials. For Windows Live ID, log into your account.

    5. Select Save.

Note:  Connect to an OData feed supports the JSON light data service format.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Get & Transform in Excel 2016

Import data from external data sources

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×