Power BI Report Builder - Exporting to EXCEL

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.

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