How to export the published power BI report using python

[Anonymous]

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.

[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 . i qlik view i could export 1million easily from table visual and need the same in power bi service .i tried using paginated report but it chokde all the memory and after 3 hrs no output as i have 42 columns in output but i could export for 5 columns only in paginated reports

[AnkitKukreja]

Hi! @Anonymous 

Please try this.

https://community.powerbi.com/t5/Community-Blog/Schedule-Automated-Data-Exports-from-Power-BI-using-a-simple-R/ba-p/1606313

[Anonymous]

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! @Anonymous 

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.

[simontaylor]

If I can add python steps I don't need to export data in that way.