Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to export the published power BI report using python

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.

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        AnkitKukreja
        Super User
        4 years ago

        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.

         

  • MallikarjunaBan's avatar
    MallikarjunaBan
    Helper III
    2 years ago

    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