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

[jperry_hisol]

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.

[v-qiuyu-msft]

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)

Best Regards,
Qiuyun Yu 

[jperry_hisol]

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]

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