How to export the published power BI report using python

[Sathiya_Beegam]

Hi,

I am new to power BI. I want to access the published(online) power BI report(It is one of the pages of a dashboard) using python and to extract the data to excel by changing the filter dynamically. At present I am doing this as manual task, export the data by changing the filters manually. I want to do the same using python(changing the filter dynamically and export data to excel).

Thanks in advance.

[AnkitKukreja]

Hi! @Sathiya_Beegam 

Please try this.

https://community.powerbi.com/t5/Community-Blog/Schedule-Automated-Data-Exports-from-Power-BI-using-...

[Sathiya_Beegam]

Hi Ankit,

Thanks for your reply, the post that you shared is for the desktop, but I need to do for the published report, which I was not developed locally(someone else did it in their local and published) and I need to extract data from it..

Thanks

Sathiya Beegam

[AnkitKukreja]

Hi! @Sathiya_Beegam 

As far as I'm aware Python is not supported on Power BI service. So, you might have to create a code in Phython itself to connect to Power BI service and export the data.