Forum Discussion

SAM_pnpn's avatar
SAM_pnpn
New Member
4 years ago

Power BI Report Builder - Exporting to EXCEL

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
Export to Excel
Power BI report builder
sevenhills's avatar
sevenhills
Icon for Super User rankSuper User
4 years ago

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