Error mapping user in connection to on-premise SSAS

[getoffmypatch]

We have a connection to on-prem SSAS that is failing refresh. After adding the mapping for the user to convert user.name@company.com to AD\user.name it is still failing although the error in the refresh now reads as follows:

This is odd because I have not added two \\ in the mapping and the test at the gateway datasource looks fine.

Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AnalysisServices: Analyseur XML for Analysis : La valeur 'DIR\\user.name' de la propriété XML pour Analysis Services 'EffectiveUserName' n'est pas valide."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"AnalysisServices"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"vd522703;Pioneer_Analysis"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: XXX

Does anyone know if this a bug or how to resolve?

[v-xiaotang]

Hi @getoffmypatch 

Thanks for reaching out to us.

please check the place in the picture below

Manage your data source - Analysis Services - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Tang

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