View source for Adding an OData feed power query to Microsoft Power BI

The following guide will assist in adding an OData feed power query to [[Microsoft Power BI]].

= Steps =
 
[[File:PowerBI_ODataFeed_URL.png|300px|thumb|right|Enter the OData feed url]]
[[File:PowerBI_ODataFeed_Login.png|300px|thumb|right|Enter the login details]]
[[File:PowerBI_ODataFeed_Endpoint.png|300px|thumb|right|Select the endpoint]]

To add a new add an OData feed power query to [[Microsoft Power BI]], follow these steps.

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

# Within '''Microsoft Power BI desktop''', select the '''Home''' tab.
# Click on the '''Get Data''' button, then '''OData Feed'''.
# 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 '''[[Model Login Type|Login Type]]''' setup for the model.
# If choosing '''Basic''', additionally enter your username and password used to login to OdataLink.
# In the dropdown, choose the fist or second entry.
#: The first entry will apply the login approach to all of OdataLink. (Recommend for those with a single account).
#: The second entry will apply the login approach to the account. (Recommend for those with multiple accounts).
#: The third entry will apply the login approach to the model.
#: The fourth entry will apply the login approach to the model and data file combination.
# Click '''Connect''' to save the login details.
# In the next dialogue, tick the endpoints to retrieve and click the '''Load''' button.

Once created, you can [[Editing an OData feed power query in Microsoft Power BI|edit the data using Power Query]].

= Related Topic =

[[Integrating OdataLink with Microsoft Power BI]] <br />