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
(Created page with "The following guide will assist in adding an OData feed power query to Microsoft Excel. = Steps = To add a new add an OData feed power query to Microsoft Excel, follow thes...") |
|||
| 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 on some version | #: 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. | ||