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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Sequence contains no matching element error

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
Status: New
Comments
v-qiuyu-msft
Community Support

Hi @justinh,

 

Which data source do you get data from? Which changes do you made to tables involved in a table merge? We will try to test on our side if you could share detail information. 

 

Also please share Power BI desktop trace log with us. You can upload it to your OneDrive and send the share link to me via private message. 

 

There is a new Power BI desktop version  2.65.5313.701. Please update your Power BI desktop to this version then check if the same version occurs. 

 

Best Regards,
Qiuyun Yu

 

justinh
Advocate IV

Hi @v-qiuyu-msft

 

Data Source: SAP HANA Import

Changes Made: Bringing a new field into the source queries before merging them.

 

Note: Everything goes well on the Power Query preview side. The merge behaves as expected with no errors. It's only after I hit Close and Apply that I get the error. 

I'll send you the trace logs. 

 

Thank you, 

-Justin

v-qiuyu-msft
Community Support

Hi @justinh,

 

I found these error in your file: 

 

"Function Name":"Group" ErrorMessage":"Order By columns should not exist when doing Group By. Check Table.Sort and/or other related functions in your M code."
"Function Name":"VisitJoinCore" ErrorMessage":"The right query is not an ODBC query."

 

I know you already checked everything is fine in Query Editor, it's better to double check it again. You can remove the merge step and keep add column step, apply change, check if you are able to load data to data model. 

 

Best Regards,
Qiuyun Yu 

justinh
Advocate IV

@v-qiuyu-msft

 

Thank you. I'll look into these errors and your reccomendation.