Forum Discussion
Send a PBI report with RLS in an email to users
Hi,
I have a requirement to email my report after data refresh to a appx 2000 users everyday. My dataset is configured for dynamic RLS. I tried subscription option but all my users reports will be delivered using my security which I do not want.
Then I tried this using Power automate by publishing the list of users in sharepoint and power automate looping through the list of users and delivering the email using their own RLS. This did work but from a performance perspective the flow is taking a lot of time to deliver when I tried for just 10 users.
Please advise if there is a better way to handle this.
1 Reply
- otravers
Community Champion
Have you used concurrency control in your flow? If not Power Automate iterates one row at a time and that's super slow:
(I assume the order in which emails are sent doesn't matter and that your logic in the flow doesn't rely on execution order - otherwise don't use concurrency because it will process things in parallel.)
