web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Dynamically exclude ce...
Power Automate
Unanswered

Dynamically exclude certain page from power bi report during exporting to a PDF via Power Automate flow

(0) ShareShare
ReportReport
Posted on by 32

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

Categories:
  • RohithKothaneth Profile Picture
    32 on at

    Sorry missed to attach my sample flow

     

    RohithKothaneth_0-1699822186394.png

    RohithKothaneth_1-1699822263078.png

    Thanks,

    Rohith

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 315 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 267

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard