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:10, 13 December 2020
, 23:10, 13 December 2020no edit summary
| Line 7: | Line 7: | ||
Before beginning, ensure you have [[Copying the OData feed URL|copied the OData Feed URL]]. | Before beginning, ensure you have [[Copying the OData feed URL|copied the OData Feed URL]]. | ||
# 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''' but is called '''New Query''' instead. | #: Note that on some version Excel, the '''Get Data''' but is called '''New Query''' instead. | ||