Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

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 ?

 

Sujata_rao090_0-1707212081214.png

 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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. 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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. 

Lozzahoff
Advocate I
Advocate 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,
L

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.