Hi,
I’m looking for a way to export a Power BI report to Excel while respecting the page-level filters applied. My goal is to generate an Excel file containing data from the semantic model that feeds the PBI report, but filtered by the values manually selected by the user in the report. For example, if I have a field called "Team" with possible values A, B, and C, and the user filters by value A, I want the generated Excel file to include only the data for value A in the "Team" field, not all values.
Additionally, I’d like to know if it’s possible to perform this action using a button in Power BI. Alternatively, I’m interested in sending the filtered data to a notebook for processing before generating the Excel file. I know PBI allows exporting a table as is, but if, for example, I want to customize the Excel file by adding multiple sheets, I understand I’d need a notebook to handle that customization. Is there a way to export the user-selected filters from the report so those selections can be used in the notebook?
I’ve tried using Power Automate for this task, but I’ve encountered the limitation of having to manually configure the columns and filters in the flow. This means the user cannot dynamically select which field values to export to Excel from the report; instead, I must predefine those values, making them static. ¿Is there a way to automate this process so that the filters applied directly in Power BI are dynamically reflected in the exported Excel file?
