Sequence contains no matching element PBI Desktop Error

[smwebb]

Hello all,

I have an end user who is encountering this issue when trying to refresh a PBIX file on his desktop and I am needing some additional support with this one. This PBIX file imports data from Dataverse from our Customer Voice / CRM environment:

Feedback Type:

Frown (Error)

Error Message:

Sequence contains no matching element

Stack Trace:

System.InvalidOperationException

at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)

at Microsoft.PowerBI.Client.Windows.AnalysisServices.ModelingTableResult.CreateColumns(Query query, TableResult tableResult, TableSchemaResult schemaTableResult, Boolean isDirectQuery, CaptionsBehavior captionsBehavior)

at Microsoft.PowerBI.Client.Windows.AnalysisServices.QueryEvaluator.LoadToModelQueryEvaluator.<EvaluateQuery>d__9.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.AnalysisServices.QueryEvaluator.EvaluationUtilities.<CaptureOutputOrException>d__0.MoveNext()

Stack Trace Message:

Sequence contains no matching element

I can provide the entire error message if needed. Let me know. Thanks.

[amitchandak]

@smwebb , Please open power query and check the steps , if there any data type issue

Refer to the old one

https://community.powerbi.com/t5/Service/Sequence-found-no-matching-elements/m-p/1713049

[smwebb]

The end user isn't experiencing the error online, only in the desktop version. No errors occur when he opens the Power Query. 

[smwebb]

Thanks, I'll have the end user provide additional detail and check on the Power Query.