Export data to Excel using Power BI Data Connector

Owned by Melanie Corletto (Deactivated), created
Last updated: Jan 16, 2024
2 min read

As the Marketplace established, “Use OData feed to import into compatible software (Microsoft Excel)”, it is possible to use the OData feature to load data from Power BI Connector to Excel.

Instructions

  1. On the Excel App, go to the “Data” section, as shown below:

2. Follow Data > From Other Sources > From OData Feed path.

3. Paste the connector URL generated under the “Power BI Connector” app.

4. Select the tables to load on Excel.

5. Once the data is loaded, it will look like the following: