Automate Export of Power BI Table with Power BI API

Hi JonPT ,

Thanks for the reply from danextian .

You can call the Export To File API in Power Automate to automate the export of tables from Power BI reports and save them to a SharePoint folder.

First, you need to ensure that you have at least one workspace in your Power BI tenant that is supported by dedicated capacity. This capacity can be any of the A, EM, or P SKUs of a Power BI report, or the A4/P1 - A6/P3 SKUs of a paged report.You also need to have a Power Automate subscription that provides access to the standard connectors.

After you create a trigger action for a process. you can select the action to run. To select a new export operation, search for Power BI and you will see the new operations listed.

You can refer to the documentation below for information:

Power Automate actions for exporting Power BI and paginated reports now available | Microsoft Power BI Blog | Microsoft Power BI

For more information on the Export To File API please refer to this documentation:

Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn

For an example of exporting a report in Power Automate please refer to this document:

Export and email a report with Power Automate - Power BI | Microsoft Learn

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!