Write, Bureaucrats, Administrators
3,246
edits
Difference between revisions of "Adding an OData feed power query to Microsoft Excel"
Jump to navigation
Jump to search
Adding an OData feed power query to Microsoft Excel (view source)
Revision as of 23:24, 13 December 2020
, 23:24, 13 December 2020no edit summary
| Line 9: | Line 9: | ||
# Within '''Excel''', select the '''Data''' tab. | # Within '''Excel''', select the '''Data''' tab. | ||
# Click on the '''Get Data''' button, then select '''From Other Sources''', then '''From OData Feed'''. | # Click on the '''Get Data''' button, then select '''From Other Sources''', then '''From OData Feed'''. | ||
#: Note that on some version Excel, the '''Get Data''' | #: Note that on some version Excel, the '''Get Data''' button is called '''New Query''' instead. | ||
# Paste the [[Copying the OData feed URL|OData Feed URL copied previously]] and click '''OK'''. | # Paste the [[Copying the OData feed URL|OData Feed URL copied previously]] and click '''OK'''. | ||
# 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. | ||