Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

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"),

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

Please modify the URL in your Power Query like below then try it again: 

 

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")&""),

 

Best Regards,
Qiuyun Yu

Anonymous
Not applicable

same error...

PowerQuery.png

 
nicg
Advocate II

I get the same error with an on-premise SQL Server source. Even if I simply duplicate a working query, the new duplicate causes this error.

Anonymous
Not applicable

Tried also this - also does not work! (PowerQuery Preview perfect, "Apply" gives error):

 

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

v-qiuyu-msft
Community Support

Hi all, 

 

Please update Power BI desktop to the latest version 2.79.5768.1082 then test again. 

 

Best Regards,
Qiuyun Yu

Anonymous
Not applicable

Same error!!!
I made a completly new report with latest version.
This desperate guessing does not help, please come up with a solution!

nicg
Advocate II

Updated, but still encountering the same error.

v-qiuyu-msft
Community Support

Hi all, 

 

Please create a support ticket to let engineers look into the issue on your side. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu

nicg
Advocate II

In our case, this problem seems related to enabling the "Enhanced Metadata Format" preview feature on an existing dataset.

Anonymous
Not applicable

Same here! The "enhanced metadata format" preview feature has some sort of critical bug in it. It will mess up your PBIX file and I could not reverse it by simply turning the feature back off. I had to revert to a previous version. Thankfully, we use source control and I had one.