Updating the permissions for an OData feed power query in Microsoft Excel

You may need to update the permissions or login details when distributing the Microsoft Excel workbook to use by other users, or if the login details have changed.

The following guide will assist in updating the permissions for an OData feed power query in Microsoft Excel.

Steps

Select the OData feed url

Edit the permissions

Enter the login details

To update the permissions for an OData feed power query in Microsoft Excel, follow these steps.

1. Within Excel, select the Data tab.
2. Click on the Get Data button, then select Data Sources Setting.

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

3. In the Data Source Settings dialogue, select the OData feed url and click on Edit Permissions.
4. In Edit Permissions dialogue, set the Privacy Level dropdown to Organizational.
5. Click the Edit button.
6. In the next dialogue, select from Anonymous or Basic matching the Login Type setup for the model.
7. If choosing Basic, additionally enter your username (e.g. email) and password used to login to OdataLink.
8. 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.

9. Click Save to save the login details.
10. Click OK to close the Edit Permissions dialogue.
11. Click Close to close the Data Source Settings dialogue.

Related Topic

Integrating OdataLink with Microsoft Excel