Forum Discussion
Helper IVData Flow EffectiveUserName Error
Thank you for the response. We are looking at all these options, which I think we have done. Still getting errors. What should be an easy fix is not. And we are working with Microsoft support as well.
Hi DPCCGF,
Thank you for reaching out in Microsoft Community Forum.
Thank you Akash_Varuna for the helpful response.
The error "AS Mashup data source is missing EffectiveUserName" usually means the gateway isn't passing the user's identity to SSAS correctly
Please follow below steps to resolve the error;
1.Make sure the on-premises data gateway is configured properly and online.
2.Please Enable SSO (Single Sign-On) with Kerberos in the SSAS data source settings in the gateway.
3.Check that user mapping is set up correctly in the gateway for the data source.
4.Re-enter credentials in the dataflow settings and ensure the correct authentication method is used
5.Make sure the gateway service account has impersonation rights on the SSAS server.
Please continue using Microsoft Community Forum.
If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan.