SAP BW connection failure

[Data-PG]

I have PowerBI Connected to = SapBusinessWarehouse.Cubes("XXX.XXX.XXX.XX", "YY", "ZZZ", [Implementation="2.0"])

PowerBI Desktop connected and pulls the data in import mode. This works perfectly well. 

I want to use same dashbaord for another SAP system. Ideally it just need change of ip address. But I keep getting an error Sequence Contains no Matching element. 

 I tried to pull the data from same sap BW cube and it wroks so not sure why my original dashboard is not working. It will be painful to create the dashbaord again. Any ideas on how to fix this ?

Feedback Type:
Frown (Error)

Timestamp:
2023-08-06T14:56:32.4885118Z

Local Time:
2023-08-06T20:26:32.4885118+05:30

Session ID:
ff9881d6-63dc-422d-b797-f4ac7f83ac73

Release:
July 2023

Product Version:
2.119.986.0 (23.07) (x64)

Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.119.986.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.EvaluationHost","Error":"Microsoft.Mashup.Host.Document.SerializedException - Microsoft.Mashup.Host.Document.Evaluation.ErrorEvaluationResult","MethodDef":"OnException","ErrorOffset":"","ErrorCode":""}

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

CLR Version:
4.8 or later [Release Number = 533320]

Peak Virtual Memory:
71.6 GB

Private Memory:
1.05 GB

Peak Working Set:
1.28 GB

IE Version:
11.1.22621.0

User ID:
faa693b5-c316-4515-88d5-310d86f869a5

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

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_b2bExternalDatasetSharing
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion
PBI_setLabelOnExportPdf
PBI_newCard

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_dynamicFormatString

PBI_oneDriveSave
PBI_oneDriveShare

PBI_gitIntegration

Enabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[Anonymous]

Hi @Data-PG ,

Based on the error message you're receiving, it sounds like there may be a problem with the connection between PowerBI and your SAP system. Please double-check that all of the connection settings in PowerBI are correct, including the IP address, login credentials, and any other relevant information.

If you have already confirmed that the connection settings are correct, try refreshing the data in PowerBI to see if that resolves the issue. You can do this by clicking on the "Refresh" button in the "Home" tab of the PowerBI ribbon.

Best regards.
Community Support Team_Caitlyn

[Data-PG1]

Thanks for checking. There are not any other issues with credentials etc. If I start building the dashbaord for 2nd SAP system it works. The requirement is that we have taken months to build one dashbaord which works on one SAP system and now we want use it for another SAP system. By changing the data source to another SAP system it should work.