Data to Excel Reporting

Hi bhalicki ,

Thanks for sharing the details, this comes up often as reports get larger and users need filtered Excel exports.

The most stable way to handle this is to use Analyze in Excel, which opens your Power BI dataset directly in Excel as a live PivotTable. It keeps all active slicers, filters, and hierarchies, while also respecting row-level security.

You can launch it from the Power BI Service (More options... then - Analyze in Excel) or add the button directly to your report for convenience.

If you want to offer advanced filtering (dynamic date ranges, multi-select, etc.), use a disconnected parameter table with dynamic M query parameters. This lets the report refresh or export exactly what the user selects without breaking the model.

Official Microsoft documentation:
Export data from a Power BI visualization
Create Excel workbooks with refreshable Power BI data
Dynamic M query parameters in Power BI Desktop
Create Excel workbooks with refreshable Power BI data

Best regards,
Sreeteja