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.
Did you ever find out what your issue was? I'm having the same issue.
Can't connect to storage account
We couldn't connect to the storage account because you don't have the required role-based-access-control (RBAC) permissions. Make sure you're assigned the "Reader and Data Access Role" for this storage account, and try again.
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.
- bh566 years agoNew Member
@PaveIR Thanks for getting back to me. I did add the roles under IAM.
Do you have your storage defined as "hierarchical namespace enabled". I do, wondering if that is my issue.
It's unclear to me at this point if this is needed to leverage ADLS Gen2 storage or not.
As an owner of your Azure Storage account, you are not automatically assigned permissions to access data. You must explicitly assign yourself an RBAC role for Azure Storage. You can assign it at the level of your subscription, resource group, storage account, or a container or queue.
You cannot assign a role scoped to a container or queue if your storage account has a hierarchical namespace enabled.
- vijaykj096 years agoFrequent Visitor
Hi Pavel,
I’m facing the same problem. I have followed all the steps given in https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-connect-azure-data-lake-storage-gen2 and read your post.
However, when I try connect my storage account to dataflow, I‘m just getting a below error message. Error message is not pointing to any particular error.
Error Details
Access denied: Please try again later or contact support. If you contact support, please provide these details.
Not sure what's the exact issue to debug. Did you face this issue?