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.
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
Hi! @Sathiya_Beegam
Please try this.
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
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.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!