What is the Analysis Services Effective User?

Question

Rajkiran Swain · Accepted Answer

Eliminates the need for Kerberos delegation when per-user authentication is used for Analysis Services data sources. By supporting Analysis Services Effective User feature, authorization checks will be based on the user specified by the EffectiveUserName property instead of using the currently authenticated user.

Khan Abrar Ahmed · Answer

EffectiveUserName is a connection string property used for passing identity information to Analysis Services. Power Pivot for SharePoint uses it to record user activity in the usage logs. Excel Services and PerformancePoint Services can use it to retrieve data used by workbooks or dashboards in SharePoint. It can also be used in custom applications or scripts that perform operations on an Analysis Services instance.     https://docs.microsoft.com/en-us/sql/analysis-services/instances/authentication-methodologies-supported-by-analysis-services