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

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.

ERROR at Loading data from SAP BW

Hello! I am working in a project with SAP BW. After I get connected to the server, I can preview my data, nevertheless when I try to load data I get this error:

rcocis_0-1611770738089.png

 

 

 

Feedback Type:
Frown (Error)

Timestamp:
2021-01-27T16:46:26.9122111Z

Local Time:
2021-01-27T17:46:26.9122111+01:00

Session ID:
0b930a23-8036-4c8a-a97a-f3fb9520be7d

Release:
December 2020

Product Version:
2.88.1385.0 (20.12) (x86)

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.RelatedColumnDetails.CopyFrom(MetadataObject 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.ObjectBody.CopyFrom(MetadataObjectBody`1 other, CopyContext context)
at Microsoft.AnalysisServices.Tabular.Column.CopyFrom(Column other, CopyContext context)
at Microsoft.AnalysisServices.Tabular.Column.CopyFrom(MetadataObject other, CopyContext context)
at Microsoft.AnalysisServices.Tabular.MetadataObjectCollection`2.<>c__DisplayClass47_0.<CopyFrom>b__2(T thisItem, T otherItem)
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.Table.CopyFrom(MetadataObject other, CopyContext context)
at Microsoft.AnalysisServices.Tabular.MetadataObjectCollection`2.<>c__DisplayClass47_0.<CopyFrom>b__2(T thisItem, T otherItem)
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.UpdateModelObjectsTree(Model updatedModel)
at Microsoft.AnalysisServices.Tabular.Model.Sync(SyncOptions options)
at Microsoft.PowerBI.Modeler.ModelManager.<>c__DisplayClass94_0.<ModelSync>b__1()
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity(ModelingActivityKind activity, Action action)
at Microsoft.PowerBI.Modeler.ModelManager.ModelSync(SyncOptions options)
at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.Dispose()
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.Dispose()
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 Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass15_0.<ExecuteSynchronizedWithModelChanges>b__0(Task`1 t)
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 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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
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.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.88.1385.0","ModuleName":"Microsoft.PowerBI.Tabular.dll","Component":"Microsoft.AnalysisServices.Tabular.Utils","Error":"Microsoft.AnalysisServices.Tabular.TomInternalException","MethodDef":"CompareCollections","ErrorOffset":"0"}

OS Version:
Microsoft Windows NT 10.0.10586.0 (x64 es-ES)

CLR Version:
4.6.2 or later [Release Number = 394806]

Peak Virtual Memory:
1.49 GB

Private Memory:
427 MB

Peak Working Set:
542 MB

IE Version:
11.0.10586.0

User ID:
5ffea578-6d26-4a16-abac-7316627725b9

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

Telemetry Enabled:
True

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Is Report V3 Models Enabled:
True

Enabled Preview Features:
PBI_NewWebTableInference
PBI_v3ModelsPreview

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_JsonTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_qnaLiveConnect
PBI_eimInformationProtectionForDesktop
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_newFieldList
PBI_cartesianMultiplesAuthoring

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Status: New
Comments
v-chuncz-msft
Community Support
rcocis
New Member

I switched to 11.2020 version and it worked!

Thanks for your fast answer!!