PowerBI Service: ...data source currently don't support refresh - Function AzureStorage.DataLake

[Anonymous]

When using variables in datalake path(URL) PB service can not reresh!?
When the path(URL) to datalake is static it works.

In PB Desktop both refreshes without problems.

Working M in PB service:
let
Source = AzureStorage.DataLake("https://xxxxx.dfs.core.windows.net/contoso-retail-dw/rssfeed/rawdata/date=2020-04-01"),

Not working M in PB service:

let
DateString = DateTime.ToText(Date.AddDays(DateTime.LocalNow(), -1), "yyyy-MM-dd"),
#"SourceString" = Text.Combine({"https://xxxxx.dfs.core.windows.net/contoso-retail-dw/rssfeed/rawdata/date=", DateString, ""}),
#"Source" = AzureStorage.DataLake(SourceString),

Query contains unsupported function. Function name: AzureStorage.DataLake

[v-qiuyu-msft]

Hi @Anonymous, 

From this document, you can see: 

"Power BI currently does not support parameterized data source definitions, also known as dynamic data sources. For example, you can't parameterize the data access function Sql.Database("SqlServer01", "AdventureWorks"). If your dataset relies on dynamic data sources, Power BI informs you that it detected unknown or unsupported data sources. You must replace the parameters in your data access functions with static values if you want Power BI to be able to identify and connect to the data sources. "

In your scenario, the SourceString is dynamic, please fix its value then test again. 

Best Regards,
Qiuyun Yu 

[Anonymous]

I can not "fix" it as this makes sense to have it dynamic, the folder is a date-partition and every day is a differnt folder the current one.
That is a very common handling to pull current data from a datalake.

Also do not understand why this is not support, but works in Desktop!?