PowerBI + Analysis Services

Hi mkowalkowski94,

Perhaps you can try to submit an idea for this requirement.(I don't think it is possible, AS source requires effectiveusername, which public access users can't provide)

EffectiveUserName

Use when an end user identity must be impersonated on the server. Specify the account in a domain\user format. To use this property, the caller must have administrative permissions in Analysis Services. For more information about using this property in an Excel workbook from SharePoint, see Use Analysis Services EffectiveUserName in SharePoint Server 2013. For an illustration of how this property is used with Reporting Services, see Using EffectiveUserName To Impersonate in SSAS.

EffectiveUserName is used in a Power Pivot for SharePoint installation to capture usage information. The user identity is provided to the server so that events or errors that include user identity can be recorded in the log files. In the case of Power Pivot, it is not used for authorization purposes.

Guy in a Cube - How authentication works with Analysis Services live connections

Regards,

Xiaoxin Sheng