Export multiple Power BI tables to a template excel file

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