Forum Discussion
SAP BW DirectQuery: Adding a new field is giving error on refresh
When I am adding a new field to Power BI Desktop from my SAP BW DirectQuery (SAP BEx Query) it is giving me following error;
Feedback Type:
Frown (Error)
Release:
December 2020
Product Version:
2.88.802.0 (20.12) (x64)
Stack Trace:
at Microsoft.AnalysisServices.Tabular.Utils.CompareCollections[T](IEnumerable`1 original, IEnumerable`1 current, Boolean isCurrentIncremental, IEqualityComparer`1 comparer, Action`1 invokeOnRemoved, Action`1 invokeOnAdded, Action`2 invokeOnMatching)
at Microsoft.AnalysisServices.Tabular.GroupByColumnCollection.CompareWith(MetadataObjectCollection`2 other, CopyContext copyContext, Action`1 invokeOnRemoved, Action`1 invokeOnAdded, Action`2 invokeOnMatching)
at Microsoft.AnalysisServices.Tabular.MetadataObjectCollection`2.CopyFrom(MetadataObjectCollection`2 other, CopyContext copyContext)
at Microsoft.AnalysisServices.Tabular.RelatedColumnDetails.CopyFrom(RelatedColumnDetails other, CopyContext context)
at Microsoft.AnalysisServices.Tabular.ChildLink`2.CopyFrom(ChildLink`2 other, CopyContext context)
at Microsoft.AnalysisServices.Tabular.Column.ObjectBody.CopyFromImpl(ObjectBody other, CopyContext context)
at Microsoft.AnalysisServices.Tabular.Column.CopyFrom(Column other, CopyContext context)
at Microsoft.AnalysisServices.Tabular.ColumnCollection.CompareWith(MetadataObjectCollection`2 other, CopyContext copyContext, Action`1 invokeOnRemoved, Action`1 invokeOnAdded, Action`2 invokeOnMatching)
at Microsoft.AnalysisServices.Tabular.MetadataObjectCollection`2.CopyFrom(MetadataObjectCollection`2 other, CopyContext copyContext)
at Microsoft.AnalysisServices.Tabular.NamedMetadataObjectCollection`2.CopyFrom(MetadataObjectCollection`2 other, CopyContext copyContext)
at Microsoft.AnalysisServices.Tabular.ColumnCollection.CopyFrom(MetadataObjectCollection`2 other, CopyContext copyContext)
at Microsoft.AnalysisServices.Tabular.Table.CopyFrom(Table other, CopyContext context)
at Microsoft.AnalysisServices.Tabular.NamedMetadataObjectCollection`2.CompareWith(MetadataObjectCollection`2 other, CopyContext copyContext, Action`1 invokeOnRemoved, Action`1 invokeOnAdded, Action`2 invokeOnMatching)
at Microsoft.AnalysisServices.Tabular.MetadataObjectCollection`2.CopyFrom(MetadataObjectCollection`2 other, CopyContext copyContext)
at Microsoft.AnalysisServices.Tabular.NamedMetadataObjectCollection`2.CopyFrom(MetadataObjectCollection`2 other, CopyContext copyContext)
at Microsoft.AnalysisServices.Tabular.TableCollection.CopyFrom(MetadataObjectCollection`2 other, CopyContext copyContext)
at Microsoft.AnalysisServices.Tabular.Model.CopyFrom(Model other, CopyContext context)
at Microsoft.AnalysisServices.Tabular.Model.MergeAffectedSubtree(MetadataObject affectedSubtreeRoot, CopyContext mergeCopyContext)
at Microsoft.AnalysisServices.Tabular.Model.HandleImpactAffectedObjects(ServerImpact impact)
at Microsoft.AnalysisServices.Tabular.Model.ApplyImpact(ServerImpact impact)
at Microsoft.AnalysisServices.Tabular.Server.CommitTransactionPrivate()
at Microsoft.AnalysisServices.Tabular.Server.CommitTransaction(ModelOperationResult& modelResult)
at Microsoft.PowerBI.Modeler.ModelManager.<>c__DisplayClass90_0.<CommitTransaction>b__0()
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass6_0`1.<RunInActivity>b__0()
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity(ModelingActivityKind activity, Action action)
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity[T](ModelingActivityKind activity, Func`1 action)
at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.Commit(Boolean recalc)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.<>c__DisplayClass17_0.<Commit>b__0()
at Microsoft.PowerBI.Modeling.Engine.Authoring.ModelAuthoringExceptionHandler.AddModelChangeResultToExceptions(Action action, ModelChangeResult modelChangeResult)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.Commit(RecalcBehavior recalcBehavior)
at Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.ApplyQueriesToModel(ILoadResultEvaluationProgressProvider evaluationProgressProvider, IExtendedModelChangeScope modelChangeScope, Action`1 beforeSchemaSyncCallback, Action`1 afterSchemaSyncCallback, Boolean& runRelationshipDetection, List`1& newTableColumnPairs, HashSet`1& existingTableInputs)
at Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.ProcessLoadInputs(IRelationshipLoader relationshipLoader, IExtendedModelChangeScope modelChangeScope, Action`1 beforeSchemaSyncCallback, Action`1 afterSchemaSyncCallback)
at Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.<>c__DisplayClass19_0.<PerformLoadInternal>b__0(IExtendedModelChangeScope modelChangeScope)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass14_0.<RunExtendedModelChangeAsync>b__0()
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.Modeling.Common.TaskExtensions.WaitAndUnpackException(Task task)
at Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.PerformLoadInternal(IRelationshipLoader relationshipLoader, IModelAuthoringChangeScopeProvider authoringChangeScopeProvider, IModelingQueryServices queryServices, Action`1 beforeSchemaSyncCallback, Action`1 afterSchemaSyncCallback, IRefreshPolicyUpdater refreshPolicyUpdater, Boolean skipImpactAnalysisWarning)
at Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.<>c__DisplayClass18_0.<PerformLoadAsync>b__1()
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.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass8_0`1.<<RunInAsyncActivity>b__0>d.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.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__7.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.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__8`1.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.Modeling.Engine.Loader.LoadToReportFlow.<PerformLoadToAnalysisServices>d__37.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.Modeling.Engine.Loader.LoadToReportFlow.<ExecuteInternal>d__32.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.Modeling.Engine.Loader.LoadToReportFlow.<Execute>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.Modeling.Engine.ModelingEngine.<LoadModelAsyncInternal>d__10.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.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass8_0`1.<<RunInAsyncActivity>b__0>d.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.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__7.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.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__8`1.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.Modeling.Hosting.ModelingService.<LoadToModel>d__16.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.<>c__DisplayClass35_0.<<StartLoadToReportFlow>b__0>d.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__1.MoveNext()
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.88.802.0","ModuleName":"Microsoft.PowerBI.Tabular.dll","Component":"Microsoft.AnalysisServices.Tabular.Utils","Error":"Microsoft.AnalysisServices.Tabular.TomInternalException","MethodDef":"CompareCollections","ErrorOffset":"0"}
CLR Version:
4.7 or later [Release Number = 528040]
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
Model Default Mode:
DirectQuery
Model Version:
PowerBI_V3
Is Report V3 Models Enabled:
True
Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_JsonTableInference
PBI_NewWebTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_qnaLiveConnect
PBI_v3ModelsPreview
PBI_eimInformationProtectionForDesktop
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_newFieldList
PBI_cartesianMultiplesAuthoring
Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
Hi Anonymous ,
Will this issue happen if using "Import" mode?
Can the previous versions, such as November 2020, work properly in this scenario?
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
3 Replies
- IceyCommunity Support
Hi Anonymous ,
Will this issue happen if using "Import" mode?
Can the previous versions, such as November 2020, work properly in this scenario?
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
- AnonymousNot applicable
I have used "DirectQuery" mode. Does not tested it on previous version. Will give it a try and let you know.
Also, if if tried to delete either a field or key figure it gives me error.
- AnonymousNot applicable
My issue is reolved by installing the November 2020 version. Thanks Icey
It should be implemented in the later releases as well.