topic Re: Power BI Report Builder - Exporting to EXCEL in Report Server

Power BI Report Builder - Exporting to EXCEL

SAM_pnpn — Fri, 29 Apr 2022 08:00:08 GMT

Hi Everyone,

When exporting a report created with Power BI Report Builder to EXCEL, the last row is sometimes hidden.

How can I prevent this?

Thank you for your information.

SAM

Re: Power BI Report Builder - Exporting to EXCEL

Icey — Tue, 03 May 2022 02:32:32 GMT

Hi SAM_pnpn ,

There is one limitation on maximum rows per worksheet in Excel. Have you checked if this is the cause?

Reference: Export a paginated report to Microsoft Excel (Report Builder) - Microsoft Report Builder & Power BI Report Builder | Microsoft Docs

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Power BI Report Builder - Exporting to EXCEL

sevenhills — Sat, 07 May 2022 00:29:33 GMT

I remember it as points vs inches and getting them rounded.
SSRS: inches, pixels, centimeters, and points.
Excel: only points.
* You can hide header if you dont need it. (=IIF(Globals!RenderFormat.Name=”EXCELOPENXML”,True,False) )

* Go through each of the textbox and see if they are less than or equal to only two decimal places

Check these links and see if this applies to your scenario:

https://social.msdn.microsoft.com/Forums/en-US/ad8c0da0-54ca-473e-950d-df81d9c2f2b8/hidden-row-at-end-of-the-report-while-exporting-into-excel-in-ssrs?forum=sqlreportingservices

https://docs.microsoft.com/en-US/troubleshoot/sql/reporting-services/workbook-hidden-rows-columns

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f3fdf372-e9c0-4127-a380-f7846fc18036/report-design-in-points-pt?forum=sqlreportingservices