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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

unexpected error - The given key was not present in dictionary in power query editor

I started getting this error something new just by bringing 2 tables and going to power query editor it throws this error can't add new colums and any thing, i have installed new version but same issue

Power bi Desktop    Version: 2.114.664.0 64-bit (February 2023)

 

any solution?

------------------------------------

Unexpected error: The given key was not present in the dictionary.
Details:
Microsoft.Mashup.Evaluator.Interface.ErrorException: The given key was not present in the dictionary. ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at Microsoft.Mashup.EngineHost.Services.StreamStorage.OpenStream(Int32 id)
at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.EncryptedStorage.OpenStream(Int32 id)
at Microsoft.Mashup.EngineHost.Services.PersistentObjectCache.TryGetValue(String key, DateTime maxStaleness, CacheVersion minVersion, Func`2 deserializer, Object& value)
at Microsoft.Mashup.Engine1.Library.PersistentCacheExtensions.TryGetValue(IPersistentObjectCache cache, String key, Func`2 deserializer, Object& value)

Status: Investigating

Hi @Anonymous 

Is your data source just these two tables ? Or are there two additional tables on top of the original data ? Do you get this error reported if you use the previous version ?

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Investigating

Hi @Anonymous 

Is your data source just these two tables ? Or are there two additional tables on top of the original data ? Do you get this error reported if you use the previous version ?

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable

Resolved:

Did talk with MS suppport,  looks like this is a issue in Feb release,  It was solved by installing the old dec release and also clearing the logs in settings//diagnostics and hard uninstall Feb release