Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Radomly my queries will fail when I make changes to tables involved in a table merge. The error is "Sequence contains no matching element"
Here are the details from the most recent one:
Feedback Type: Frown (Error) Timestamp: 2018-12-19T18:55:49.9806420Z Local Time: 2018-12-19T13:55:49.9806420-05:00 Session ID: a1966006-6b55-4382-952f-97598b22c354 Release: December 2018 Product Version: 2.65.5313.621 (18.12) (x64) Stack Trace: at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate) at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelSchemaSynchronizer.GetFinalColumnNameFromId(IDictionary`2 finalColumnMap, String id) at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelSchemaSynchronizer.AddSchemaChangesForGroupColumns(ModelChange modelChange, String tableName, IDictionary`2 columnFinalNames) at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelSchemaSynchronizer.CreateModelChangeToSyncSchemas(EditTableInfo editTableInfo, ITableInput tableInput, String tableName, String tableDescription, FinalNameResults finalNamesResult, Boolean renameSourceColumns, Boolean includeColumnCreation) at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelSchemaSynchronizer.EditExistingTable(ITableInput loadInput, EditTableInfo editTableInfo, FinalNameResults finalNamesResult) at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelSchemaSynchronizer.ApplyQuerySchemaToModel(IModelInput modelInput, IExtendedModelChangeScope modelChangeScope, IReadOnlyList`1& tablesConvertedToImport) at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.ApplyQueriesToModel(IAnalysisServicesLoadContext loadContext, IExtendedModelChangeScope modelChangeScope, ModelChange modelChangeToExecuteBeforeSchemaSync, Boolean& runRelationshipDetection, List`1& newTableColumnPairs, HashSet`1& previouslyLoadedInputs) at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.ProcessLoadInputs(IExtendedModelChangeScope modelChangeScope, Action relationshipAutodetectStartCallback, ModelChange modelChangeToExecuteBeforeSchemaSync) at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.<>c__DisplayClassb.<PerformLoadInternal>b__7(IExtendedModelChangeScope modelChangeScope) at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.<>c__DisplayClassf.<RunExtendedModelChangeAsync>b__e() at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.Tasks.Task.Execute() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.PowerBI.Client.Windows.Utilities.TaskExtensions.WaitAndUnpackException(Task task) at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.PerformLoadInternal(Action relationshipAutodetectStartCallback, ModelChange modelChangeToExecuteBeforeSchemaSync, Boolean skipImpactAnalysisWarning) at Microsoft.PowerBI.Client.Windows.Modeling.PowerQueryToModelLoader.<>c__DisplayClass2.<PerformLoadAsync>b__0() at System.Threading.Tasks.Task`1.InnerInvoke() at System.Threading.Tasks.Task.Execute() --- 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.<LoadQueriesToAnalysisServices>d__1f.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.<LoadToAnalysisServicesAsync>d__31.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__3.MoveNext() OS Version: Microsoft Windows NT 10.0.17134.0 (x64 en-US) CLR Version: 4.7 or later [Release Number = 461808] Peak Virtual Memory: 46 GB Private Memory: 4.08 GB Peak Working Set: 7.95 GB IE Version: 11.345.17134.0 User ID: 0c2c7a8c-99b8-4b6c-9fd5-80adf4204e38 Workbook Package Info: 1* - en-US, Query Groups: 6, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Model Default Mode: Import Snapshot Trace Logs: C:\Users\E168047\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot973407217.zip Enabled Preview Features: MIntellisense PBI_ColumnProfiling PBI_variationUIChange PBI_EnableWebDiagramView Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_PdfImport PBI_PythonSupportEnabled PBI_showIncrementalRefreshPolicy PBI_showManageAggregations PBI_FuzzyMatching PBI_improvedFilterExperience PBI_qnaLiveConnect Enabled DirectQuery Options: PBI_DirectQuery_Unrestricted TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.