Power BI Report Builder - Exporting to EXCEL

[SAM_pnpn]

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

[sevenhills]

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-en...

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...

[Icey]

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 ...

Best Regards,

Icey

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