Write, Bureaucrats, Administrators
3,244
edits
Difference between revisions of "Updating the permissions for an OData feed power query in Microsoft Excel"
Jump to navigation
Jump to search
Updating the permissions for an OData feed power query in Microsoft Excel (view source)
Revision as of 17:27, 23 February 2023
, 17:27, 23 February 2023no edit summary
| Line 16: | Line 16: | ||
#: 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 '''Privacy Level''' dropdown to ''' | # In ''Edit Permissions'' dialogue, set the '''Privacy Level''' dropdown to '''Organizational'''. | ||
# Click the '''Edit''' button. | # Click the '''Edit''' button. | ||
# In the next dialogue, select from '''Anonymous''' or '''Basic''' matching the '''[[Model Login Type|Login Type]]''' setup for the model. | # In the next dialogue, select from '''Anonymous''' or '''Basic''' matching the '''[[Model Login Type|Login Type]]''' setup for the model. | ||