"EffectiveUserName' XML for Analysis property is not valid" error when refreshing from SSAS

[DepthOfFocus]

We have a very simple Power BI report which connects to a SSAS (SQL Server Analysis Service) Tabular model, using an import query.

The goal is to have this published to our workspace, and have it refresh daily. To accomplish this, we've:

- Created a Windows Service Account

- Added that Windows service account to the SSAS tabular model, with Full Control (administator) 
- Added the SSAS server/Tabular model to the gateway - No issues 

- Set up the gateway connection in the Dataset details - No issues

However, when we try and refresh the dataset (either manually/or scheduled), it generates the ""EffectiveUserName' XML for Analysis property is not valid" error, and refresh fails.

Any ideas?

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: The 'FirstName@CompanyDomain.ca' value of the 'EffectiveUserName' XML for Analysis property is not valid."}},{"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":"ssasServer123\\tabular;SalesDataModel"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: FactDataSales.

[lbendlin]

does it work with a regular account?

[v-kkf-msft · Accepted solution]

Hi @DepthOfFocus ,

1. Add this Windows user as the administrator of the SSAS instance.

2. Use this Windows account as the connection credentials in the data source settings.

3. Map the Power BI login account to this Windows account.

4. Use this gateway for the dataset, then refresh.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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