Forum Discussion
Error Exporting Power BI using Power Automate using RLS
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,
Could you elaborate some more on how to set the report level filter dynamically in the export connector?
Thanks!
Thanks. I had already found where to set the report level filters, but I'm specifically interested in how to inject the user email into the export request, as you suggested in an earlier reply. How would this work?
Hi
The user email, role name and CustomData (if any) should be part of Identities UserName (as per above screen shot.
But, in my case, I have not used the action 'Export to File for Power BI reports", rather I have used the API directly "Export to File in Group" series and passed User email as part of BODY.
Thanks
Ritesh
Whatever works for you. The flow component takes care of a lot of the plumbing that you have to do manually when you do it via API calls (including waiting for the rendering to finish etc).
The flow component achieves most of the things but it does NOT allow certain things.
My requirement was to generate Power BI reports in PDF based on RLS and should be based on Service Principal rather than a USER account, which generates an Access Token. You cannot pass a Token in the flow component as Authorization but API allows it to pass as part of the Header.