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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

lbendlin's avatar
lbendlin
Super User
4 years ago

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).

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.