Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Paginated reports in premium don't work properly with Globals!RenderFormat

If we have a report where we want to hide some fields when exporting to Excel if we try to use the Globals!RenderFormat.Name or Globals!RenderFormat.IsInteractive values then the item is also not visible when ran from PBI workspace.

 

Please can this be resolved so we get the same behaviour as with std SSRS where we can see the items in SSRS and they are only hidden when exported to the specified format i.e. Excel.

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @jperry_hisol

 

If you want the specify item is hidden when exporting to Excel file, you can set the visibility condition with Globals!RenderFormat.Name built-in function like below: 

 

=IIF(Globals!RenderFormat.Name="EXCELOPENXML", true, false)

 

e1.PNGe2.PNG

 

 

Best Regards,
Qiuyun Yu 

jperry_hisol
Advocate I

Thanks @v-qiuyu-msft, any idea where the IsInteractive property does not work as expected for paginated via Power BI as it would be useful if we could use that so we dont need to write conditions for multiple export formats. 

v-qiuyu-msft
Community Support

Hi @jperry_hisol

 

Based on my research, the Globals!RenderFormat.IsInteractive returns False in Power BI premium workspace and exported Excel file. I wouldn't suggest you use this built-in field to set column visibility. 

 

Best Regards,
Qiuyun Yu