Power BI Connection with ADLS Gen2

[mayurwadhwani]

Hello Experts,

I'm trying to connect Power BI Desktop to ADLS Gen2, but I can't. I have an Azure subscription and a storage account. I created a container with some CSV files. Assigned the Storage Blob Data Reader role to users of Power BI Desktop. When connecting to ADLS Gen2, specify the URL/container-name of the Data Lake storage endpoint and click Organization Account to sign in, but even after clicking Sign In, Power BI Desktop keeps on loading and no error is displayed. I can connect with my account key, but I would like to connect with my organizational account.
Note: The credentials for this organizational account work correctly when used in the Azure portal or when connecting to SharePoint via Power BI Desktop.

Any help or suggestions are welcome.
Thank you,
Mayur

[v-stephen-msft · Accepted solution]

Hi @mayurwadhwani ,

Before you connect ADLS Gen2 to Power BI, you must have the following 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.

 Then you have the following to note.

1.Currently, in Power Query Online, the Azure Data Lake Storage Gen2 connector only supports paths with container, and not subfolder or file. For example, 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.

2.Microsoft doesn't support dataflow or dataset refresh using OAuth2 authentication when the Azure Data Lake Storage Gen 2 (ADLS) account is in a different tenant. This limitation only applies to ADLS when the authentication method is OAuth2, that is, when you attempt to connect to a cross-tenant ADLS using an Azure AD account. In this case, we recommend that you use a different authentication method that is not OAuth2/AAD, such as the Key authentication method.

Analyze data in Azure Data Lake Storage Gen2 by using Power BI - Power Query | Microsoft Docs

Power BI - Accessing Azure Data Lake Gen 2 Files (11) - Hands On Demo! - YouTube

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.