Forum Discussion
Dataflows Storage can't connect to ADLS Gen2
- 6 years ago
bh56 you have a little bit different issue. You have to set correct access roles in IAM (access control) in Azure Portal. You have to be the owner of the resource (not inherited one).
My problem was solved via MS Support - the only thing was that I had to delete a container (named powerbi) that I had in my ADLS Gen2. The mechanism behind creates this container automatically. Now everything works for me.
Let me know whether you need some additional assistance.
When I remove Power BI Service in the role of a Reader from Access Control (IAM) in my storage account, then I get the "Can't connect to storage account"
When I add it back, then I am again stuck with the error message that I have shown in the first post.
Does anybody know how to overcome those issues?
This error is extremely misleading. See below response, based on MS documentation. It has solved the issue for me.
Grant permissions to Power BI services
You need to grant the Power BI service reader and data access roles in your created storage account. They are both built-in roles, so the steps are straightforward. Follow the steps in Assign a built-in RBAC role.
Go to your resource -> IAM -> in the Add role assignment window, select the Reader and Data Access role. Then use search to locate the Power BI Service application. Repeat the same steps for the Storage Blob Data Owner role, and assign the role to both the Power BI Service and Power BI Premium applications.