Dynamically exclude certain page from power bi report during exporting to a PDF

[rohithkothaneth]

Hello,

I have a PBI report which are driven based on the report level filter that generate report pages accordingly to the passed filter value dynamically. The report visual gets populated dynamically and for certain client certain pages comes as blank pages as there are no data for the values passed.  I'm Looking to find a way to dynamically exclude those blank/empty pages by any means as I will need to export the report into a PDF document using pwoer automate.

Was thinking an approach to create a page within the rpeort as a place holder that has table visual with page names and measure on the corresponding pages to check if there are rows for that particular page.  But I'm not sure how to get the report pages lists dynamically inside the Power automate flow that uses PBI connector "Export to a file for the Power BI report" which refreshes the report visual accordingly based on the dynamic report level filter that gets passed into the same connector for a particular client. 

Here I cannot use RLS as it is during the export of the PDF that I need certain pages for certain client based on the report filters that gets passed to be excluded from the list and for certain clients I will need all the pages if the data is available.

Thanks,
Rohith

[Idrissshatila]

Hello @rohithkothaneth,

the only way i can think of is that to duplicate the power bi file and make one only for the export to pdf hwhere you hide the blank page.

other than that i can't think of a possible solution.

[rohithkothaneth]

Thank you @Idrissshatila for your response.

In my case, the indicual PDF's are generated dynamically based on the filter that is passed as report level filter during the PDF creation part and BLANK pages are not always the same and it keep on changing based ont he dynamic data it gets in for that particular month for that particular client.