Forum Discussion

AyushAwasthi's avatar
AyushAwasthi
Helper I
1 year ago
Solved

Export multiple Power BI tables to a template excel file

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 ...
Need Help
  • v-menakakota's avatar
    v-menakakota
    1 year ago

    Hi AyushAwasthi ,

    Thanks for the update, Going forward 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.

    • 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.

    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 

v-menakakota's avatar
v-menakakota
Community Support
1 year ago

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