Automate powerbi report visual data extract

[Avanthi99]

Hi All,

I'm looking for options to automate the download of powerbi visual data with filters applied. we use this data for our testing purpose - during the sevral rounds of UAT and quality testing. Every time we go to report apply filter and manually export the data from powerbi report visual - Looking to avoid all these manual steps and automate the export of data with correspoding filters in. 

I was tossing between the various option

1) Power Automate - RPA - Using the recorder simulate the export of data from powerbi and run teh flow in powerautomate.

    Challenge here is recording the filters is a bit tricky.

2) Using Powerbi rest API - can e use restapi calls here.

3) Using powerautomate and running the query against a dataset .

Please give me a guidence on pros and cons and best approach to dela with this.

Thanks in advance for your help.

[Kedar_Pande · Accepted solution]

Best: Power BI REST API for flexibility and reliability.
Good: Power Automate with DAX for querying datasets easily.
Last Resort: RPA due to maintenance and filter issues.

[Anonymous · Accepted solution]

Hi @Avanthi99 ,

Agree with Kedar_Pande, using the Power BI REST API might be the best approach.

If you prefer a less code-intensive solution, combining Power Automate with dataset queries could be a good middle ground. This approach leverages the ease of Power Automate while allowing you to run specific queries against your dataset.

Here's the viedo which introduces it step by step:

Power BI export to excel and csv with Power Automate 

In addition, here's the blog about data export from power bi using R/Python Script:

Schedule Automated Data Exports from Power BI usin... - Microsoft Fabric Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Avanthi99]

Thanks @Kedar_Pande 

Have you ever tried Rest API to export data - Challenge I'm focing is finding the visual id. Powerbi is not straight forward to extract the visual id.

[Kedar_Pande · Accepted solution]

Best: Power BI REST API for flexibility and reliability.
Good: Power Automate with DAX for querying datasets easily.
Last Resort: RPA due to maintenance and filter issues.