Connect to an OData feed (Power Query)

Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.

1. In the POWER QUERY ribbon tab, select From Other Source > From OData Feed.

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

3. Select OK.

4. 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.