OData Feed

Summary

Item Description
Release State General Availability
Products Power BI (Datasets)
Power BI (Dataflows)
Power Apps (Dataflows)
Excel
Dynamics 365 Customer Insights
Analysis Services
Authentication Types Supported Anonymous
Windows
Basic
Web API
Organizational Account
Function Reference Documentation OData.Feed, ODataOmitValues.Nulls

Capabilities supported

  • Basic
  • Advanced
    • URL parts
    • Open type columns
  • Select related tables

Load data from an OData Feed in Power Query Desktop

To load data from an OData Feed in Power Query Desktop:

  1. Select the OData or OData Feed option in the connector selection.

  2. Choose the Basic button and enter a URL address in the text box. This URL should be the root of the OData service you want to connect to. For example, enter http://services.odata.org/V4/northwind/northwind.svc/. Then select OK.

    OData URL selection

    If the URL address you enter is invalid, a Warning icon warning icon will appear next to the URL textbox.

  3. If this is the first time you're connecting using the OData Feed, select the authentication type, input your credentials (if necessary), and select the level to apply the authentication settings to. Then select Connect.

    OData credentials selection

  4. From the Navigator dialog, you can select a table, then either transform the data in the Power Query Editor by selecting Transform Data, or load the data by selecting Load.

    Web table selection

    If you have multiple tables that have a direct relationship to one or more of the already selected tables, you can select the Select Related Tables button. When you do, all tables that have a direct relationship to one or more of the already selected tables will be imported as well.

Load data from an OData Feed in Power Query Online

To load data from an OData Feed in Power Query Online:

  1. Select the OData or OData Feed option in the connector selection.

  2. In the OData dialog that appears, enter a URL in the text box.

    OData online sign in

  3. If this is the first time you're connecting using the OData Feed, select the authentication kind and enter your credentials (if necessary). Then select Next.

  4. From the Navigator dialog, you can select a table, then transform the data in the Power Query Editor by selecting Transform Data.

    Web table selection

    If you have multiple tables that have a direct relationship to one or more of the already selected tables, you can select the Select Related Tables button. When you do, all tables that have a direct relationship to one or more of the already selected tables will be imported as well.