Getting forbidden error while Connecting to ADLS Gen2 from PowerBI

[Anonymous]

I'm trying to conect adls gen2 from Power BI Desktop but getting error as access to the resource is forbidden.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Please kindly clear the permission in data source setting. and makes ure you've followed the prerequisites:

• An Azure subscription. See Get Azure free trial.
• A storage account that has a hierarchical namespace. Follow these instructions to create one. This article assumes that you've created a storage account named myadlsg2.
• You are granted one of the following roles for the storage account: Blob Data Reader, Blob Data Contributor, or Blob Data Owner.
• A sample data file named Drivers.txt located in your storage account. You can download this sample from Azure Data Lake Git Repository, and then upload that file to your storage account.
• Power BI Desktop. You can download this from the Microsoft Download Center.

Then follow below steps to connect it:

1. From the Home tab of the Ribbon, select Get Data, and then select More.

2. In the Get Data dialog box, select Azure > Azure Data Lake Store Gen2, and then select Connect.

3. In the Azure Data Lake Storage Gen2 dialog box, you can provide the URL to your Azure Data Lake Storage Gen2 account, filesystem, or subfolder using the container endpoint format. URLs for Data Lake Storage Gen2 have the following pattern:

   https://<accountname>.dfs.core.windows.net/<filesystemname>/<subfolder>

   You can also select whether you want to use the file system view or the Common Data Model folder view.

   Select OK to continue.

4. If this is the first time you're using this URL address, you'll be asked to select the authentication method.

   If you select the Organizational account method, select Sign in to sign into your storage account. You'll be redirected to your organization's sign in page. Follow the prompts to sign into the account. After you've successfully signed in, select Connect.

   If you select the Account key method, enter your account key and then select Connect.

5. The next dialog box shows all files under the URL you provided in step 4 above, including the file that you uploaded to your storage account. Verify the information, and then select Load.

Please note that :

Currently, in Power Query Online, the Azure Data Lake Storage Gen2 connector only supports paths with container, and not subfolder or file.

https://<accountname>.dfs.core.windows.net/<container> will work, while https://<accountname>.dfs.core.windows.net/<container>/<filename> or https://<accountname>.dfs.core.windows.net/<container>/<subfolder> will fail.

[mhossain]

@Anonymous 

See below link, hope this helps:

https://nishantrana.me/2020/09/07/error-access-to-the-resource-is-forbidden-while-trying-to-connect-to-azure-data-lake-storage-gen2-using-power-bi-desktop/

http://nisalbi.blogspot.com/2019/11/error-when-connecting-to-azure-data.html