SAP BW DirectQuery: Mapping of key figure with the same name but different technical id

[Anonymous]

I am getting the following error when I tried to refresh my SAP BW Query in Power BI Desktop. It was working fine previously. I have made changes in the BEx Query Level and deleted a Key Figure and inserted another one with the same name. However, both technical ids are different. Is there any way to avoid this error or map the old key figure to new one.

The error is;

Feedback Type:
Frown (Error)

Error Message:
An internal error has occured.

Stack Trace Message:
An internal error has occured.

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"}

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

ModelChangeResult: {"changes":[{"itemDelete":{"entity":"Key Figures","property":"Key Figure 01","objectType":"Measure"}}, {"newMeasureCreated":{"entity":"Key Figures","name":"Key Figure 01","expression":"EXTERNALMEASURE(\"[Measures].[719M6KDWZEAXVENE6OWSYPM5U]\", INTEGER)"}}],"hasQueryImpact":true}

Note: The previous key figure/measure id is "719M6KDWZEAXVCLBKK8ZCTWGJ" and need to map it to "719M6KDWZEAXVENE6OWSYPM5U".

[Anonymous]

There @fahadanwar ,

As the official document said, The data source settings (for example, server name) can be changed by selecting Edit Queries > Data source settings. The settings for any Parameters can be changed by selecting Edit Queries > Manage Parameters.

Hope these help.

https://businessintelligist.com/2017/01/30/how-to-expose-key-values-from-sap-bw-in-power-query/

https://answers.sap.com/questions/12851890/is-microsoft-powerbi-replacement-for-bw-query-desi.html

https://dl.mitsubishielectric.com/dl/fa/document/catalog/ssc/l03158/l03158a.pdf

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

This is a common case as key figures with the same name but different technical id can do one of the following;

1. Either give option to map

2. Or Delete old ids and add new ones

None of this is happening and none of your suggested links have this information.