Extracting report from powerbi using power automate

Hi Anonymous ,

Here's a concise action plan to achieve this:

1. Use the "Export To File" action for Power BI reports in Power Automate. This action allows you to specify the report and the page you wish to export.

2. After exporting the report, you can use the "Create file" action in Power Automate to store the exported file in SharePoint. Specify the SharePoint site and folder where you want to store the report.

3. If you prefer to store the results in a database, consider using the appropriate connector in Power Automate for your database (e.g., SQL Server, Azure SQL Database). Use the "Insert row" action to add the extracted data into your database table. Ensure your report data is in a suitable format for database insertion.

For more information, please refer:

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

Save a paginated report to OneDrive for work or school or SharePoint Online - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

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