Forum Discussion
Skilled Sharer¿How to Dynamically Export Filtered Data from Power BI to Excel Using a Button or Power Automate?
Super Useramaaiia you can club your columns inside a field parameter and provide slicers in the page. With the use of field parameters, users can select which fields needs to be exported.
Refer the below video on how to store the power bi data as csv withour manually mapping the columns.
https://www.youtube.com/watch?v=BnTipbooeP0
Did I answer your question? If yes, please mark my post as a solution.
Thanks,
Jai
Skilled SharerThank you for your response and for sharing the video. I’ve reviewed it, and while it demonstrates how to create a button to export data to Excel or CSV, the configuration appears to be manual. Specifically, the columns and data exported are predefined when setting up the button, and the export does not consider the filters applied dynamically by the user on the Power BI report.
This approach doesn’t align with my initial requirement, which is to ensure that the exported data respects the filters that the user applies directly on the report page. For example, if a user selects only “A” in a "Team" slicer, the exported file should include data filtered to that specific selection dynamically, without having to preconfigure the filters or columns in the button manually.
Additionally, I’m looking to export the data for all visualizations on the page, respecting the page-level filters applied by the user. The goal is to generate a single file where each visualization on the page is represented as a separate table, all filtered by the selections made by the user on the report.
Do you know if there’s a way to achieve this kind of dynamic export, where the user’s interactions and page-level filter selections directly determine the content of the exported file, including data from all visualizations?