Kiyan Chan on 30 Sep 2021 06:58:36
Currently pagniated report on Power BI Service could not export to excel with correct layout, when there is a toggle of expanding/collapsing columns from right to left hand side.
This limitation should be improved in future.
""The report item in the top-left corner that can be toggled can continue to be toggled in Excel. Report items that can be toggled and share vertical or horizontal space with the report item that can be toggled in the top-left corner cannot be toggled in Excel.""
https://docs.microsoft.com/en-us/sql/reporting-services/report-builder/exporting-to-microsoft-excel-report-builder-and-ssrs?view=sql-server-ver15#show-and-hide