Forum Discussion

haiyangl104's avatar
haiyangl104
Frequent Visitor
5 years ago
Solved

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:

 

 

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"

 

 

1 Reply