Get data from Power BI with Python

[fortuit]

Hello,

Does anyone know how to connect to a dataset in Power BI desktop and export the content of this dataset using Python scripts?

I often see examples of using pandas package to import data in Power BI (from external sources to Power BI) but not the other way (from Power BI to external service)...

The idea is to be able to read data from power BI report, a bit like what can be done with pandas through "pandas.read_excel" when one wants to retrieves data from an xlsx file.

With the Power BI REST API, it seems we can only get list of dataset, not the content of dataset.

Any idea ?

[dm-p]

Hi @fortuit,

With the introduction of external tools into preview, you can create something to connect to Power BI Desktop via the local port your model exposes. David Eldersveld has a great 4 part worked example for doing this with Python - he uses Jupyter as a means of writing DAX against the model to extract data and you could probably leverage some of his work to see if you can do what you want.

Regards,

Daniel

[Greg_Deckler]

@fortuit - Maybe via the Power BI REST API?