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 21:28, 13 December 2020
, 21:28, 13 December 2020no edit summary
| Line 11: | Line 11: | ||
#: Note that on some version Excel, the '''Get Data''' but is called '''New Query''' instead. | #: Note that on some version Excel, the '''Get Data''' but 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. | ||
# If choosing '''Basic''', additionally enter your username and password used to login to odatalink. | # If choosing '''Basic''', additionally enter your username and password used to login to odatalink. | ||
# In the dropdown, choose the fist or second entry. | # In the dropdown, choose the fist or second entry. | ||