Export data to Excel using Power BI Data Connector
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
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: