¿How to Dynamically Export Filtered Data from Power BI to Excel Using a Button or Power Automate?

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.