Forum Discussion
Solution SpecialistDataflows Storage can't connect to ADLS Gen2
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.
Community SupportHi PavelR ,
Here is someone who had the same problem with you and has solved it. Please refer to Unable to connect to Azure Data lake Gen2 storage on Power BI to use DataFlow.
Before you can configure Power BI with an Azure Data Lake Storage Gen2 account, you must create and configure a storage account.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Solution SpecialistHi v-yingjl you are referring to the different issues than I am struggling with. It does not help me at all.
As I have already mentioned I have created and configured a storage account.
- PavelR
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.