Forum Discussion
Error Exporting Power BI using Power Automate using RLS
Hi All, I am trying to create Power BI Subscription logic (with filters and RLS) using Power Automate. We have Premium Capacity also. The requirement is to generate separate PDFs for each user bas...
The links provided by Anonymous are interesting but a little misleading. It doesn't send emails as per RLS, but as per Role. The user identity is the one who renders all the reports, but as that role. It's nice if you have roles defined and want to send the same email to all users within a role, but it will not work with personalized individual emails as in your case. In your case you need to leave the role settings alone and manipulate the "Identities Username" dynamically. I think.
Hi
Finally, I managed to implement customized Power BI subscription logic using Power Automate, which Service Principal to generate an Access Token and then using Power BI REST API's the output files are generated as per RLS.
Here is the snapshot
😀