Export Power BI table into a python script

[JananiSethu]

Hi,

I need to export the table from the power bi desktop to the python script in a dataframe or JSON format and this has to be done without publishing it in the power bi workspace.

Please help me if there is any solution for this.

Thanks,

Janani S

[alexrm]

Hello, as stated in another forum post, I have recently created an utility for python, aiming to read tables data from any locally opened PowerBI report. You can take a look at https://pypi.org/project/pbi-local-connector/. Don't hesitate to share feedback about it!

[MallikarjunaBan]

Thanks for writing this. My requirement is to export a Power BI visual content into a excel  file with 1.5 million records on average per day and save it in my local drive. Is there a way to do this as well.  specific for a table visual i need .

Thanks,

Bandi

[davehus]

Hi @JananiSethu ,

Here is a link that might be of use to you. Export data from Power BI to csv using Python – The BIccountant

Did I help you today? Please accept my solution and hit the Kudos button.

[JananiSethu]

Hi @davehus,

Thanks for the suggestion.

But my requirement is to get the table in the data frame or JSON format directly to python. I cannot store it in a CSV file and again read it through python.

[davehus]

Hi @JananiSethu ,

I understand now. I don't know of any mechanism to do it from Desktop. There may be a way to do it through a PowerBI pro licence and an using the xmla endpoint but I've not tried it and it's not what you need anyway, as that's all in the service.

Maybe someone else on the community might know.