Forum Discussion
Power BI - Export Report via Power Automate with Row Level Security
Hi Anonymous ,
I don't think this specific error message is related to the values you provide in the identities.
Sounds to me as if it's related to the permissions of the user who runs the flow in Power Automate. What permissions does he have in the folder of the report and dataset? Viewer/Member/Admin?
We found out the reason. The "Export to File for Power BI Reports" action is running in the context of the user who executes the flow instead of the connector's account. This is different from the other action who takes the context of the connector's user account instead.
As far as I know it depends on the connection you choose for the Power Automate step which calls the API.
I would try with a user which is a member or an admin in the relevant Power BI workspace.
We found out the reason. The "Export to File for Power BI Reports" action is running in the context of the user who executes the flow instead of the connector's account. This is different from the other action who takes the context of the connector's user account instead.