View source for Relinking an existing OData feed power query in Microsoft Excel

You may need relink an existing OData feed power query to another [[OData Feed URLs|OData feed url]].

This can occur if you built a Power Query to work for a specific [[Models|model]] or [[Data Files|data file]] and need to relink it to another. 

= Steps =

[[File:Excel_DataSourceSettings.png|300px|thumb|right|Select the old OData feed url]]
[[File:Excel_ODataFeed_URL.png|300px|thumb|right|Enter the OData feed url]]
 
To relink an existing OData feed power query in Microsoft Excel, follow these steps.

Before beginning, ensure you have [[Copying the OData feed URL|copied the OData Feed URL]].

# Within '''Excel''', select the '''Data''' tab.
# Click on the '''Get Data''' button, then select '''Data Sources Setting'''.
#: Note that on some version Excel, the '''Get Data''' button is called '''New Query''' instead.
# In the ''Data Source Settings'' dialogue, select the [[OData Feed URLs|OData feed url]] and click on '''Change Source'''.
# In the next dialogue, paste the [[Copying the OData feed URL|OData Feed URL copied previously]] and click '''OK'''.


= Related Topic =

:[[Integrating OdataLink with Microsoft Excel]]
:[[Linking your data to a Standard Microsoft Excel Report]] 
<br />