How to read Data From Power BI Dataset to Python

[JuliMed]

Is there any way to connect to a Power BI dataset and export this data to a Pandas DF? I've been looking for this online but found nothing except using adodbapi which is failing to install on our side due to the 'build_py_2to3' package and we have not been able to overpass this.

This is the video we found 

We are trying to get this data from a PowerBI dataset as the data comes from different Power BI Dataflows where all transformations are occurring and it is not stored in any DB unfortunately.

Any hint will be much appreciated.

Thank you in advanced!

[alexrm]

Hello, this comes maybe too late, but for others who might need such a tool, I created a very simple utility to read table from a locally-opened PowerBI report. Support for cloud-stored reports is planned. You can found it at https://pypi.org/project/pbi-local-connector/. Don't hesitate to share feedback about it.

[v-henryk-mstf · Accepted solution]

Hi @JuliMed ,

For now, there is no efficient way to export data directly from powerbi to panda df.

My suggestion is that you can export the data as a csv file in powerbi first, and then import the following two packages by command.

import pandas as pd
import datetime as dt

Then refer to the detailed documentation below to further import the data you need.

How to import data into Pandas dataframes

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@JuliMed , XMLA Endpoint, Cmdlets, and REST APIs are three options, that can help you

https://docs.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools

https://docs.microsoft.com/en-us/rest/api/power-bi/

https://docs.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps