topic The credentials provided for AzureDataLakeStorage source are invalid in Developer

The credentials provided for AzureDataLakeStorage source are invalid

haiyangl104 — Tue, 08 Jun 2021 21:09:03 GMT

Hi,

I'm trying to refresh my Power BI dataset that comes from ADLS Gen 2 Storage. Refresh works fine on Power BI Desktop, but on the Web App I receive the following error:

I've mirorred exactly the same settings I used on Power BI Desktop here, but still receive the following error:

Here's the Power Query used:

let
Source = Csv.Document(AzureStorage.DataLake("https://xxxxxxxxxxxxxxxxxxxx.dfs.core.windows.net"){[#"Folder Path"="https://xxxxxxxxxxxxxxxxxxxxxx.dfs.core.windows.net/xxxxxxx/xxxxxxxx/xxxxxxxxx/csv_files/",Name="xxxxxxxxxxxx.csv"]}[Content],[Delimiter=",", Columns=22, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
#"Promoted Headers"

Re: The credentials provided for AzureDataLakeStorage source are invalid

V-lianl-msft — Fri, 11 Jun 2021 06:43:43 GMT

Please whitelist the Azure IP's for your region in the ADLS.

https://www.microsoft.com/en-us/download/details.aspx?id=41653&751be11f-ede8-5a0c-058c-2ee190a24fa6=True

You could refer to this blog:

https://medium.com/microsoftazure/how-to-refresh-a-firewall-enabled-azure-data-lake-storage-gen2-data-source-from-power-bi-service-1c5f440cd93b

Another situation is that Since the Azure and O365 are in two different Tenants your getting the error "Failed to update data source credentials: The given data source kind is not supported"

You could refer to this blog:

https://www.purplefrogsystems.com/paul/2017/06/connecting-power-bi-to-azure-data-lake-store-across-tenants/