Map non AD users

[gheesalias]

Hi,

In this link,
Tech Tip Thursday: authentication with Analysis Services live connections : https://powerbi.microsoft.com/en-us/blog/tech-tip-thursday-user-principal-name-upn-mapping-in-power-...
i is mentioned there is some tweak which could be used to fake the map non-AD users , so that Analysis services connection could be demoed from a non AD system.

Any idea about that tweak? 

[v-qiuyu-msft]

Hi @gheesalias,

Based on my research, the email address that we sign into Power BI with is passed into EffectiveUserName has to match a UPN property on a local Active Directory account. For this reason, the Analysis Services machine has to be joined to a domain. The domain of the email address has to match a UPN Suffix within local Active Directory.

In your scenario, if you mean non-AD users are email address sign in the Power BI Service. You can follow below links to use Map User Names feature:

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

Usernames with Analysis Services

Best Regards,
Qiuyun Yu

[gheesalias]

Many Thanks @v-qiuyu-msft, but in the links you gave, we have a video 

https://www.youtube.com/watch?time_continue=197&v=Qb5EEjkHoLg

In this video, at 3:05, he says for demo and testing purposes, we can fake it.. Any idea how to do that? I think he is not explaining how to do that. 😞

[v-qiuyu-msft]

Hi @gheesalias,

The "fake" you mean is to use Map user names to make the SSAS server can recognize the email address which signed in Power BI Service.

The email address signed in service can be different from the domain the SSAS server belong to. For example, email address is cube@microsoft.com, while SSAS server domain is contoso.com. As the UPN Suffix in SSAS server active directory is contoso.com, we can't directly pass the cube@microsoft.com to SSAS server. So we need to replace the cube@microsoft.com as cube@contoso.com use Map user names feature. I would suggest you double check the articles share in my original post.

Best Regards,
Qiuyun Yu