404 "The specified container does not exist" When trying to connect to Azure Data Lake Gen2

[StianBWLNG]

Hi,

I want to connect PowerBI to my Azure Data Lake Gen2.

I use PowerBI Desktop > Get Data > Select Azure Data Lake Gen2 > Enter the URL I find under properties of my container in Azure portal (https://mytestdatalake.blob.core.windows.net/container) and choose to authenticate with my account.

Then I get the following error:
Details: "AzureDataLakeStorage failed to get contents from 'https://mytestdatalake.blob.core.windows.net/container'. Status code: 404, description: 'The specified container does not exist.'."

What I have tried:

1. I have verified in the portal that I have contributor access to the data lake and the container
2. I have tested authenticating using the account key instead, same error
3. I have accessed the same container using Azure Portal, Azure Storage Explorer and Python SDK without issues
4. I am able to connect PowerBI to a normal storage account (without hierachical namespace) without issues using account key
5. I tested creating a fresh data lake with a container with public anonymous access, still got the same error
6. I read a FAQ relating to DataBricks which said to create container from code, not from portal, so i deleted the old and created it using Python SDK and then tried to connect. Same error.

I am uncertain of what more to test so I turn to you and hope for some advice 🙂

[StianBWLNG]

Thanks! You are absolutely right. I used the url in the properties of the container. When I switched to the url listed as Primary Endpoint in the properties of the data lake itself it works. 
You made my day! Thanks again 🙂

[georgerizk]

Thank you, just wanna to add to that make sure to add the Account Access Key to avoid facing other issue "Access Forbidden" 

[Rogerren]

where and how to add the account access key?

[dheerr]

hi @Rogerren , how did you resolve this issue?

[ibarrau · Accepted solution]

Hi. I think the URL you are using is wrong. If you go to the storage explorer inside Azure Portal from Web you can find the correct url in properties. It looks like this:
https://[company].dfs.core.windows.net/[container]/[folder]/[file]

If you want to try databricks you need to create a table for the cluster. Then connect via Spark or Databricks connector in Power Bi. It works good.

Hope this helps