Then select Next.įrom the Navigator dialog, you can select a table, then transform the data in the Power Query Editor by selecting Transform Data.Ĭonnecting to Microsoft Graph REST APIs from Power Query isn't recommended or supported.

If this is the first time you're connecting using the OData Feed, select the authentication kind and enter your credentials (if necessary). In the OData dialog that appears, enter a URL in the text box. To load data from an OData Feed in Power Query Online:

Load data from an OData Feed in Power Query Online When you do, all tables that have a direct relationship to one or more of the already selected tables will be imported as well. 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. Then select Connect.įrom 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. 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. If the URL address you enter is invalid, a warning icon will appear next to the URL textbox. This URL should be the root of the OData service you want to connect to. Select the OData or OData Feed option in the connector selection.Ĭhoose the Basic button and enter a URL address in the text box. To load data from an OData Feed in Power Query Desktop: More information: Lack of Support for Microsoft Graph in Power Query Load data from an OData Feed in Power Query Desktop

Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.

Online app builder odata feed