Export multiple Power BI tables to a template excel file

[AyushAwasthi]

I have a Power BI file which has multiple pages and there is a table on every page of the report. The table has same columns on each page but I have different measures on each page to show different rows in the table.

I want to have a button at one place to just copy or export the data in each table of the PBI to a template excel and preferably then be sent to the user on his email.

Can this be done using Power Automate or any other automation?

Thanks in advance!

[v-menakakota]

Hi  @AyushAwasthi  ,
Thanks for reaching out to the Microsoft fabric community forum.

In addition to the helpful response shared earlier, I’d also recommend reviewing the official Microsoft documentation which outlines how to automate Power BI report exports using Power Automate.

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

I would also take a moment to thank  @Cookistador  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
 

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Best Regards, 
Menaka Kota 
Community Support Team 

[Cookistador]

Hello @AyushAwasthi 

Indeed, to achieve this kind of feature, Power automate is your friend

For each table, you have to catch the query (in dax) and in Power Auomtate, run a query against dataset

I helped another user to achieve something similar under the following post:

https://community.fabric.microsoft.com/t5/Desktop/Downloading-Data-through-Power-Automate/m-p/465640...

Do not hesiste to ask if you need more help

[AyushAwasthi]

But in my case the user is making slicer selections, and if I copy the DAX query those selections are hard coded.

Will this work if the user makes a different slicer selection? Also I want to copy the rows to an already created template excel. How can that be achieved?

[v-menakakota]

Hi @AyushAwasthi ,

Thanks for the clarification! You’re absolutely right when using DAX queries captured via Performance Analyzer, slicer values get hard-coded into the query, which means they won’t reflect real-time user selections.

To address this exact limitation, I’d recommend using Paginated Reports with parameters, which allow you to dynamically pass slicer selections at runtime.

• You can define report parameters that correspond to slicers (like Region, Product, Date).

• These parameters accept values dynamically, either from a Power BI button using Power Automate, or from a scheduled/triggered flow.

• The export will always reflect the user’s current selections not fixed one.

Please note: To publish and automate paginated reports, your workspace must be in a Power BI Premium capacity or you must have a Power BI Premium Per User (PPU) license.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Best Regards, 
Menaka Kota 
Community Support Team