Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a Data Lake Gen 2 hierarchical file system in Azure, and I'm trying to connect to it in Power BI with the beta connector. My account has all of the necessary permissions to view and author data in the Azure Portal, as well as in Storage Explorer. But, when passing the Primary File Service Endpoint as the URL for the connector, I get the following error code: "Access to resource is forbidden."
I don't need to use dataflows to write data, I just need to access data from the Data Lake via Power BI.
Any guidance is appreciated!
Solved! Go to Solution.
UPDATE:
I added my account to the "Storage Blob Data Reader" role in the Data Lake and now the connector works perfectly! I assume you can do this with user groups, too.
Most Microsoft documentation on Power BI and Azure Data Lake Gen2 describe granting Power BI Service and Power Query Online "Reader" roles in the Data Lake, but this is not necessary in my case.
Hi,
Where is exactly we must put/assign the role ?
In Data Lake ? I can't find the Access Control (IAM), please help.
Thanks,
UPDATE:
I added my account to the "Storage Blob Data Reader" role in the Data Lake and now the connector works perfectly! I assume you can do this with user groups, too.
Most Microsoft documentation on Power BI and Azure Data Lake Gen2 describe granting Power BI Service and Power Query Online "Reader" roles in the Data Lake, but this is not necessary in my case.
I have done some investigation on this and found that I could connect to ADLS Gen 2 Storage Accounts within an EA subscription, but not any within a CSP subscription. If you look at the Service Principals available to add to the Storage Account in IAM you get different options for inbuilt Power BI Service Principals depending on which subscription you have, which suggests some back end permissions issue.
I have raised this with Support and so far got confirmation that there is something Subscription specific, but no details yet. However I have retested this morning and found that I can't connect to my EA subscription based storage acocunts any more, so perhaps the whole thing is now broken.
Hi @Anonymous ,
After researching, maybe, the blog can help you to implement it through Azure Databricks.
For now, it is not supported to get data from Azure Data Lake Gen2 directly. To make Power BI better, you can submit your request at Power BI Ideas and vote it up.
Best Regards,
Xue
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |