Forum Discussion
Exporting data to Excel with current layout
I am using Power BI report Server and it is absolutely crucial for my client to export data with current layout to excel. Some tables use hirarchy and thus usual export doesnt produce the result I a...
The only way to control the formatting of the layout when exporting to Excel from Power BI Report Server at the moment (as of Jan 2023) is to build your report as a paginated report. Unlike the cloud service the on-prem report server does not support this functionality for pbix based reports.