Power BI Connection with ADLS Gen2

• 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.