Search code examples
powerbiazure-storagepowerbi-desktop

Unable to Connet to Azure Gen 2 Store with Power BI

Whenever I attempt to connect to Azure GEN 2 (ADLSv2) with Power BI I'm immediately get the message: "Access to the resource is forbidden". I am not asked for SAS keys or tokens or anything

enter image description here

enter image description here

Can someone let me know how to resolve this issue?

Solution

  • You have given the endpoint for azure blob storage in azure data lake connector. That is the reason you are getting the error. In order to get the datalake's endpoint from the azure portal, follow the below steps.

    • Click the data lake storage account in the azure portal.

    • Select the endpoint under settings as shown in the below image.

    • Under data lake storage, copy the URL

    • Paste this URL in azure data lake gen2 power bi connector.