Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

That's not what I meant. Run the flow with high level permissions but inject the target user email into the RLS table via the report level filter.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Ibendlin

Apologise but I don't understand when you say "inject in RLS table via report level filter".

Here RLS table sits in AAS.

Please correct me.

Thanks

Ritesh

 

 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks Rico for your link.

      I have already these options, and it works fine when "identities UserName" and "user running Power Automate" are the same but it fails when I want to run Power Automate for some other user, who has RLS setup and the source is AAS.

      I think solution could be using Service Principal along with CUSTOMDATA, I will try this only the proper tenant-level access is granted to Service Principal.

      However, I was looking for some example who has implemented this logic.

      Thanks

      Ritesh

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        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.