Write, Bureaucrats, Administrators
3,246
edits
Difference between revisions of "Adding an OData feed power query to Microsoft Excel"
Adding an OData feed power query to Microsoft Excel (view source)
Revision as of 23:53, 14 December 2020
, 23:53, 14 December 2020no edit summary
| Line 15: | Line 15: | ||
#: 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. | ||
# 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 '''[[Model Login Type|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. | ||