Power BI PDF Export with dynamic Security filter using power automate.

Hi Team,

I have created a Power BI PDF export through power automate for a power bi report having multiple pages. Have added export button on each page where user can download the PDF file on click of a button. This report is embedded in an application through Java integration.

When a user login to application (Note – Client id filter is applied through java), user can see data for selected client only where the user has permissions to see the data (due to RLS – created through User email id)
Problem is when dashboard data is filtered due to RLS but in export User gets data for all client ids.

These are the steps I have followed:

From the first step a HTTP URL is generated that is used in Power BI Desktop

Second Step exporting PPT , added User, dataset and RLS details in identities. Not sure what to add in Identityblob Blob Value – 1* (Bottom) which is a mandatory field.

Need a solution where user should only get data for selected client id in the export or alternatively current state of the report can be exported as an image.

Quick Links

Leaderboard > Power Automate