Unexpected error: An item with the same key has already been added

[mcflurry]

I got this error in Navigator just clicking on a table to preview it and before Loading it.

It happens on a few tables.

Feedback Type:
Frown (Error)

Timestamp:
2021-05-06T08:28:25.3414515Z

Local Time:
2021-05-06T10:28:25.3414515+02:00

Session ID:
08ace65f-a09d-40e8-9701-d055705737c2

Release:
April 2021

Product Version:
2.92.1067.0 (21.04) (x64)

Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException
Microsoft.Mashup.Evaluator.Interface.ErrorException: An item with the same key has already been added. ---> System.ArgumentException: An item with the same key has already been added. ---> System.ArgumentException: An item with the same key has already been added.
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at Microsoft.Internal.DictionaryTracing.AddWithTracing[K,V](IDictionary`2 dictionary, K key, V value, IEngineHost host, Boolean keyIsPii, Boolean valueIsPii)
at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RetrieveKeysForTable(String schemaName, String tableName, Keys columnNames)
at Microsoft.Mashup.Engine1.Library.Common.QueryResultTableTypeValue.get_TableKeys()
at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.NewTableType(Query query)
at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.get_Type()
at Microsoft.Mashup.Engine1.Library.Common.NavigationPropertiesHelper.AddNavigationPropertiesToTable(NavigationPropertiesRecord record, DbEnvironment environment, TableValue table, NameGenerator nameGenerator)
at Microsoft.Mashup.Engine1.Library.Common.NavigationPropertiesHelper.NavigationPropertiesRecord.get_Item(SchemaItem key)
at Microsoft.Mashup.Engine1.Library.Common.NavigationPropertiesHelper.LinkTableFunctionValue.TypedInvoke()
at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue0`1.Invoke()
at Microsoft.Mashup.Engine1.Language.Query.NestedJoinQuery.get_RightTable()
at Microsoft.Mashup.Engine1.Language.Query.NestedJoinQuery.NestedJoinRecordType.get_RecordType()
at Microsoft.Mashup.Engine1.Language.Query.NestedJoinQuery.NestedJoinRecordType.get_TypeIdentity()
at Microsoft.Mashup.Engine1.Runtime.TypeValue.Equals(Value value, _ValueComparer comparer)
at Microsoft.Mashup.Engine1.Runtime.Value.Equals(Object obj)
at Microsoft.Mashup.Evaluator.Services.ValueSerializer.WritePrimitiveType(ITypeValue typeValue, Boolean topLevel, AllowCustomTypes allowCustomTypes, TypeHandle typeHandle, String nullableText, String nonNullableText)
at Microsoft.Mashup.Evaluator.Services.ValueSerializer.WriteTypeReference(ITypeValue typeValue, Boolean topLevel, AllowCustomTypes allowCustomTypes)
at Microsoft.Mashup.Evaluator.Services.ValueSerializer.FinishWriting()
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass11_0.<TryReportException>b__1()
at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass12_1`1.<OnBeginGetResult>b__0()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)
at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.92.1067.0","ModuleName":"","Component":"Microsoft.Mashup.Engine1.Library.Common.DbEnvironment","Error":"System.ArgumentException","MethodDef":"RetrieveKeysForTable","ErrorOffset":""}

OS Version:
Microsoft Windows NT 10.0.19042.0 (x64 es-ES)

CLR Version:
4.7 or later [Release Number = 528372]

Peak Virtual Memory:
38.4 GB

Private Memory:
578 MB

Peak Working Set:
802 MB

IE Version:
11.789.19041.0

User ID:
6f28c3ee-8e17-4968-ab00-a09c4f326e47

Workbook Package Info:
1* - es-ES, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Enabled Preview Features:
PBI_JsonTableInference
PBI_NewWebTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_eimInformationProtectionForDesktop
PBI_newFieldList

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_cartesianMultiplesAuthoring

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[mcflurry]

Solved disabling relasionships columns.

[v-lili6-msft]

hi

It's pleasant that your problem has been solved, 😁

I will close this thread as the issue.

Regards,

Lin