Forum Discussion

JuliMed's avatar
JuliMed
Frequent Visitor
4 years ago
Solved

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 sid...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    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.

alexrm's avatar
alexrm
New Member
2 years ago

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.