Hello,
I have a scenario where I have a report which are driven based on the report level filter that generate report pages accordingly to the passed filter value dynamically. Now there are report visual that gets populated dynamically for certain client which has blank pages. Looking to find a way to dynamically exclude those blank/empty pages by any means here within the power automate flow that I have.
Was thinking to create a page as a place holder with table visual that has page names and measure on the corresponding pages to check if there are rows for that particular page. But after that im 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

Report
All responses (
Answers (