cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
haiyangl104
Frequent Visitor

The credentials provided for AzureDataLakeStorage source are invalid

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:

 

haiyangl104_1-1623185982357.png

 

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

haiyangl104_0-1623185933298.png

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"

 

 

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

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

You could refer to this blog:

https://medium.com/microsoftazure/how-to-refresh-a-firewall-enabled-azure-data-lake-storage-gen2-dat... 

 

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

View solution in original post

1 REPLY 1
V-lianl-msft
Community Support
Community Support

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

You could refer to this blog:

https://medium.com/microsoftazure/how-to-refresh-a-firewall-enabled-azure-data-lake-storage-gen2-dat... 

 

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

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors