Forum Discussion
How to read Data From Power BI Dataset to Python
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.
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!
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 dtThen 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.
3 Replies
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
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 dtThen 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.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.
