Error on apply Power Query: Expression in partition n/a in table n/a references an unknown entity

[Anonymous]

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

This PowerQuery Source gives a preview without any error, but when "close and apply" this error is shown:

Failed to save modifications to the server. Expression in partition n/a in table n/a references an unknown entity

When I change the source to static string it works fine!?

let
Source = AzureStorage.DataLake("https://xxxxx.dfs.core.windows.net/contoso-retail-dw/rssfeed/rawdata/date=" & "2020-03-29"),

[ColinRE]

Oddly, 3 years later, I am still having issues. I am using a dynamic parameter in Power Query and it doesn't like it. Ideas?