Add a Page Break to a Paginated Report WHEN exporting to excel only

[mgtaylor3]

Hi all, Been trying to do this to no avail...

I have a paginated report   that has 2 Tablix's   one for MTD and the other for YTD data.

Both Identical in columns.... only on soem MTD's   a column might not be used  and thus when exportign to excel throws the columns out of sync..

Is it possible, to run the report have both Tablix's showing  but when I export to excel I would like a Page break to be added to the end of the firt tablix, thus giving me 2 seperate worksheets, whe it;s exported.

Key is, to have the 2 showing on the Powerbi Service....   but split in Excel.  I've tried using the =Globals!RenderFormat.Name="EXCEL"     in various places but still no joy..

TIA.

[mgtaylor3 · Accepted solution]

Ok I managed to finally get this to work...

In the Page Break properties of the tablix, within the Disabled section I added this formula:

=IF(Globals!RenderFormat.Name="EXCELOPNXML",FALSE,TRUE)

now it does what I'm asking it to do, No page break when runnign the report in Power Bi , BUT does when exportign to EXCEL.

Great... hope that helps anyone else..