Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
I am uncertain of what more to test so I turn to you and hope for some advice 🙂
Solved! Go to 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
Happy to help!
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 🙂
Thank you, just wanna to add to that make sure to add the Account Access Key to avoid facing other issue "Access Forbidden"
where and how to add the account access key?
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
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |