Write, Bureaucrats, Administrators
3,246
edits
Difference between revisions of "Updating the permissions for an OData feed power query in Microsoft Excel"
Updating the permissions for an OData feed power query in Microsoft Excel (view source)
Revision as of 17:17, 14 December 2020
, 17:17, 14 December 2020no edit summary
(Created page with "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 follow...") |
|||
| Line 11: | Line 11: | ||
#: Note that on some version Excel, the '''Get Data''' button is called '''New Query''' instead. | #: Note that on some version Excel, the '''Get Data''' button is called '''New Query''' instead. | ||
# In the ''Data Source Settings'' dialogue, select the [[OData Feed URLs|OData feed url]] and click on '''Edit Permissions'''. | # In the ''Data Source Settings'' dialogue, select the [[OData Feed URLs|OData feed url]] and click on '''Edit Permissions'''. | ||
# In ''Edit Permissions'' dialogue, set the | # In ''Edit Permissions'' dialogue, set the '''Privacy Level''' dropdown to '''Private'''. | ||
# Click the '''Edit''' button. | # Click the '''Edit''' button. | ||
# In the next dialogue, select from '''Anonymous''' or '''Basic''' matching the '''Login Type''' setup for the model. | # In the next dialogue, select from '''Anonymous''' or '''Basic''' matching the '''Login Type''' setup for the model. | ||