Extracting data from a shared BI Report

[Anpham2812]

Hi Experts,

Is there anyway to automate the process when extracting data to an excel file from a table? i have upto 20+ table data to extract on daily basis & i do not have permission to access to the datasource. 

Thank you in advance.

[v-deddai1-msft]

Hi @Anpham2812 ，

You can take a look at the following blog about use power bi automate with rest API to export data from your report data:

Category Archives: Power BI API 

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

Best Regards,

Dedmon Dai