topic Re: Get data from Power BI with Python in Developer

Get data from Power BI with Python

fortuit — Mon, 07 Sep 2020 14:42:19 GMT

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 ?

Re: Get data from Power BI with Python

Greg_Deckler — Mon, 07 Sep 2020 17:20:08 GMT

@fortuit - Maybe via the Power BI REST API?

Re: Get data from Power BI with Python

dm-p — Mon, 07 Sep 2020 19:40:09 GMT

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