Forum Discussion
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-
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:
Do not hesiste to ask if you need more help
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?
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 TeamHi AyushAwasthi ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.Hi AyushAwasthi ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
-