Forum Discussion

JC_Silva's avatar
JC_Silva
Frequent Visitor
4 years ago

Emailing a Power BI exported PDF with Power Automate using Dynamic RLS

Hello,

 

I have a Power BI report that has dynamic row level security based on a user's email. The expectation is for once a week, an email to be sent out to each user with a pdf extract of this report that only has the data as it pertains to them (the complete dataset has every users data).

In the report I have set up one role tied to the users email:

Because the report is to be used by the entire organization, instead of typing in every email, I have used a distribution group that contains every users email.

When I test viewing the published report, this works without issue. The challenge I run into is on setting up the the Power Automate flow. Specifically in the identities section. For the "Identities Username - 1" I have used my own email:

When I test the flow, it succesfully executes and emails myself and my coworker. Howerver, the attached PDF is a report of only my data (not my coworkers). My undestanding is this is b/c I am specificing my email as the token being passed on in the flow. My question is how to I set it up so it dynamically generates the pdf of the user that is being emailed. 


Thanks in advnace for any guidance.

 

2 Replies