Forum Discussion
Extracting report from powerbi using power automate
Hi All,
I have a requirement where I need to extract a page of the report from powerbi using power automate and then store the results in a sharepoint or database in a table form .
Report is the bottom visual where we have scenarios(A,B,C,D...) and against each scenario there is a assesment done (0,1,2 nos are assigned based on some calculations)
Now what I need to do is daily extract this only this particular report page via power automate or something and store the results in a table form as shown in the top table visual in a database or sharepoint . Is this possible to do ?
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
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.
2 Replies
LozzahoffAdvocate I
Hi,
Yes I do it but I don't extract the report but the data underneath. This is the process I'd follow; look at the DAX behind the report; construct a query in DAX that mirrors the table I want to insert into and then execute a 'Run a Query Against a Dataset' task against the Semantic Model in Power Automate followed by a Insert Row Task or similar.
Thanks,
LHi 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
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.