Anonymous's avatar
Anonymous
Not applicable
6 years ago
Status:
New

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 Powe...
Data Modeling
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

I'm not sure if this is the same issue, but it may be related. Scenario:

  1. New file with Enhanced Metadata enabled. Worked for less than 15min in Power Query to get connections to SharePoint sites. This was a March 2020 file I am 99% sure.
  2. Put file aside for a few days. Worked in April 2020 version for 4.5hrs. Constantly saving, and SharePoint (via OneDrive for Business) making version backups as I go.
  3. Have basic data mode the way I want it. Close file go eat lunch.
  4. Come back, open file and refresh my data. All of my test visuals (just 3) went blank with errors. none of the data was there. Opened up Power Query, and all M code was from 4-5 days ago! All of my M code was gone!
  5. Restored a version. Again, all data is there in the data model. Open up Power Query, almost no M code. All from 4-5 days ago again.

 

Nothing I did brought it back. I had to start from scratch basically, which I did in a new file with enhanced metadata turned off.

Completed Ideas