Forum Discussion
¿How to Dynamically Export Filtered Data from Power BI to Excel Using a Button or Power Automate?
Hi amaaiia ,
Please follow the steps below:
1. You could export the filtered data from a report visual in Power BI Desktop and save as .cvs file:
2. We could get data from CSV :
3. We could also export the filtered data in the Power BI service directory
Our Excel export shows the value for ‘A’. The first row of our spreadsheet shows the filter that Power BI used when we try to extract the data.
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your response.The option to export data by clicking on the three dots of a visualization does work, but it only allows me to export the data for one visualization at a time, resulting in multiple Excel files if I need to export data from several visualizations. The point here is that I need to export data directly from the semantic model, with the values filtered in the report by the user applied to the output data from semantic model.
My goal is to export all the visualizations on the report page simultaneously into a single Excel file. Ideally, each visualization would be represented as a separate table or sheet within the same file, and the export should respect the page-level filters applied by the user.
Do you know if there’s a way to achieve this functionality in Power BI, either natively or through integration with other tools like Power Automate or custom scripting?
This process has to be done automatically, the user press a button in PBI and automatically en email is sent to him with his filters in report applied to an excel table with data from semantic model.
Hi amaaiia ,
We recommend exploring the use of the Power BI API or custom connectors that can trigger exports based on user interaction.
Best regards,
Lucy Chen
