Forum Discussion
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
- v-xiaotangCommunity Support
Hi JC_Silva
Thanks for reaching out to us.
I'd like to help you, but I am not an expert in Power Automate, sorry for not being able to help... For professional technical support, you can go to Automate forum, Forums - Power Platform Community (microsoft.com)
Good luck!
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
- KiranHosakotePost Patron
Hi JC_Silva
For dynamic selection of slicers and filters at runtime, take a look at this option with Power Automate + Power BI Pro, which uses a different Flow. https://medium.com/bi-helper/burst-your-power-bi-reports-838ab593f7bc
And if you want to skip Power Automate and use just Power BI Pro to export to PDF with multiple filters and slicers applied, see https://medium.com/bi-helper/automated-distribution-of-power-bi-reports-and-dashboards-25fde6c68af0.