cancel
Showing results for 
Search instead for 
Did you mean: 

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
Community Support

Hi @Oliverpmone

 

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

Advocate I

same error...

PowerQuery.png

 
Frequent Visitor

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.

Advocate I

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

Community Support

Hi all, 

 

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

 

Best Regards,
Qiuyun Yu

Advocate I

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

Frequent Visitor

Updated, but still encountering the same error.

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

Frequent Visitor

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

Frequent Visitor

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.

Idea Statuses