Export Data to Excel from powerbi embed reports | Direct lake semantic Model

[change007]

• Bug: Export to XLSX fails with ExportExcel_ExportDataServiceFailure error when Row-Level Security (RLS) is enabled AND visual filters are applied in Power BI Embedded reports
• Root Cause: When exporting, the API request shows "FiltersDescription": "No filters applied" despite filters being active in the UI - the export endpoint ignores visual-level filters when RLS with USERPRINCIPALNAME() is active
• Impact: Users cannot export filtered data to Excel format when RLS is enabled, forcing them to either export ALL data (security risk) or use CSV format (poor user experience)
• Technical Details: The /export/xlsx endpoint generates a semantic query without WHERE clauses for applied filters, requesting up to 1,000,000 rows ("Count": 1000000) instead of respecting the filtered dataset visible in the embedded report
• Workaround Required: Must either (1) temporarily remove all filters before export, (2) use CSV format instead of XLSX, or (3) disable RLS - all of which degrade functionality
• Environment: Power BI Embedded with embed tokens, RLS using [users] == USERPRINCIPALNAME(), occurs with DirectLake  datasets

Expected Behavior: Export should respect both RLS context AND applied visual filters, exporting only the data visible to the user in the current filtered state.

[Bart_Berg]

Interesting! It seems like a couple of customers of us (Embedded BI platform) have the same issue..