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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Something went wrong - Sequence contains more than one element

I tried to create a variable to switch between our systems (dev/test/prod).  I did it but when I tried to save the file this error came up.  Once this error came up, the program was stuck in a loop and I could not cancel, go back and change, save or anything.  I had to kill the app in task manager.  PBI Task Manager.pngsomething went wrong.png

 

Feedback Type:
Frown (Error)

Timestamp:
2021-08-26T13:33:20.8475484Z

Local Time:
2021-08-26T09:33:20.8475484-04:00

Session ID:
ba46a846-8ce5-49a3-93e6-5e41a282ab92

Release:
August 2021

Product Version:
2.96.901.0 (21.08) (x64)

Stack Trace:
System.InvalidOperationException
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
at Microsoft.PowerBI.Modeling.Engine.DataModel.Utilities.DataModelExtensions.GetLastKnownQueryName(IQueryableObject obj)
at Microsoft.PowerBI.Modeling.Engine.DataModel.Utilities.DataModelExtensions.GetLinkedQuery(IQueryableObject obj, TwoWayDictionary`2 queryOriginalNameToRuntimeIdMap, ModelingMashupDocument mashupDocument)
at Microsoft.PowerBI.Client.Windows.ReportExtensions.GetLinkedQuery(Report report, IQueryableObject modelItem)
at Microsoft.PowerBI.Client.Windows.ReportExtensions.GetLinkedQuery(Report report, String modelItemName)
at Microsoft.PowerBI.Client.Windows.DataModelHostService.GetRefreshPolicyExtendedInfoCore(String tableName)
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass6_0`1.<ExecuteOnUIThread>b__0()
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass5_0.<ExecuteOnUIThread>b__0(Object t)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.96.901.0","ModuleName":"Microsoft.PowerBI.Modeling.Engine.dll","Component":"Microsoft.PowerBI.Modeling.Engine.DataModel.Utilities.DataModelExtensions","Error":"System.InvalidOperationException","MethodDef":"GetLastKnownQueryName","ErrorOffset":"92"}

OS Version:
Microsoft Windows NT 10.0.19043.0 (x64 en-US)

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

Peak Virtual Memory:
102 GB

Private Memory:
640 MB

Peak Working Set:
862 MB

IE Version:
11.789.19041.0

User ID:
2c22e4d0-065d-454c-8601-3a8487033c79

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

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_JsonTableInference
PBI_NewWebTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_rdlNativeVisual

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_dynamicParameters
PBI_enhancedTooltips

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Status: New
Comments
FredQ
Frequent Visitor

Here is what I did to create the parametercreate parameter.png

v-chuncz-msft
Community Support

@FredQ 

 

The latest version works fine on my end. Try to recreate the report.