Automate powerbi report visual data extract

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.