Forum Discussion
Query won't load bc key is not found in dictionary.
Hello All!
I am recieving an error when applying several queries but I am not sure what the error message means in order for me to resolve.
Here's what I get:
Feedback Type:
Frown (Error)
Timestamp:
2020-06-04T02:15:36.9879871Z
Local Time:
2020-06-03T21:15:36.9879871-05:00
Session ID:
8d9dda39-505c-40bf-8c50-b05878b54b22
Release:
May 2020
Product Version:
2.81.5831.821 (20.05) (x64)
Stack Trace:
at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at Microsoft.PowerBI.Modeling.Engine.Telemetry.LoadModelTelemetryExtensions.LogQueriesLoadToModelCompleted(LoadModelTelemetry loadModelTelemetry, IEnumerable`1 queries, Dictionary`2 errorMessages, Dictionary`2 queryLoadReasonsDictionary, ModelingMashupDocument mashupDocument, IEnumerable`1 loadInputs)
at Microsoft.PowerBI.Modeling.Engine.Loader.LoadToReportFlow.<EvaluateQueries>d__30.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Modeling.Engine.Loader.LoadToReportFlow.<ExecuteInternal>d__29.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Modeling.Engine.Loader.LoadToReportFlow.<Execute>d__28.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingService.<LoadToModel>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.<>c__DisplayClass35_0.<<StartLoadToReportFlow>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.81.5831.821","ModuleName":"Microsoft.PowerBI.Modeling.Engine.dll","Component":"Microsoft.PowerBI.Modeling.Engine.Telemetry.LoadModelTelemetryExtensions","Error":"System.Collections.Generic.KeyNotFoundException","MethodDef":"LogQueriesLoadToModelCompleted","ErrorOffset":"53"}
OS Version:
Microsoft Windows NT 10.0.18363.0 (x64 en-US)
CLR Version:
4.7 or later [Release Number = 528040]
Peak Virtual Memory:
44.3 GB
Private Memory:
2.28 GB
Peak Working Set:
2.11 GB
IE Version:
11.836.18362.0
User ID:
7193acc9-2fbf-4c51-b3f0-e350b09322d4
Workbook Package Info:
1* - en-US, Query Groups: 5, fastCombine: Enabled, runBackgroundAnalysis: False.
Telemetry Enabled:
True
Snapshot Trace Logs:
C:\Users\irvinej1217\Microsoft\Power BI Desktop Store App\FrownSnapShot1039317944.zip
Model Default Mode:
Import
Model Version:
PowerBI_V3
Is Report V3 Models Enabled:
True
Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_NewWebTableInference
PBI_qnaLiveConnect
PBI_realTimeRefresh
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_v3ModelsPreview
PBI_hierarchicalSlicerCreation
Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_inlineExplore
PBI_relativeTimeSlicer
PBI_dataSearchCuration
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
Any help is, as always, greatly appreciated!!
Hi Anonymous ,
This error only occur when you modify power query? If you re-install the powerbi desktop to newest version , and run it , will it work well? By the way, I think you also could post this problem in Issues or open a support ticket for this problem
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- dax
Community Support
Hi Anonymous ,
This error only occur when you modify power query? If you re-install the powerbi desktop to newest version , and run it , will it work well? By the way, I think you also could post this problem in Issues or open a support ticket for this problem
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- katemkeFrequent Visitor
I am currently running into the same issue; when i try to load changes from Power Query Editor, I am getting the error "the given key was not present in the dictionary". The data source has not changed, but i have cleared and reset the credentials. I have also updated the Desktop App to the October 2021 version, but none of this has helped the error. All queries are loading fine within Query Editor. Any suggestions?