Forum Discussion
Connect to Azure
I am attempting to use "Connect to Azure" in the service.
As part of my preparation, I created an Azure ADLS2 Blob with Hierarchical names enabled and set myself to "owner" as documented.
In Desktop, I cannot connect to it using my Azure credentials. However, I tried with storage keys and this works. After publishing, my refresh also works using storage key authentication.
Within Power BI Admin, Connect to Azure finds my Subscription / Resource Group / Storage Account.
After pressing Save I get the working message "Almost Done".
Next I get an error "Access Denied", but no useful diagnostics just "...please try again later..."
This seems to be a problem with my Azure AD permissions, given that storage keys work for a datasource.
Looking for diagnostic recommendations.
2 Replies
- amitchandakSuper User
tommy_g , Please see if you have already checked these and they did not help
https://www.sqlshack.com/how-to-access-data-from-azure-blob-storage-using-power-bi/
https://www.coatesdatastrategies.com/blog/querying-data-in-azure-data-lake-storage-gen-2-from-power-bi
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-azure-data-lake-storage-integration- tommy_gHelper V
Your suggestions were helpful, I now understand Azure connections better from the Desktop.
They did not provide any insights into my issue when working in the Power BI Service.
I am mindful of "Preview" status and maybe I'm too early, the goal will be leveraging ADLS2 content through Dataflows.
Here is the error I receive. Ordinarily I would suspect Azure issues, but I can connect in every other way described in your reference material, and I would not know what else could be involved.