Forum Discussion

Raoul's avatar
Raoul
Regular Visitor
9 years ago
Solved

SSAS MD / Power BI Gateway / Effective user names

Hi there,   I have been trying to set up a SSAS MD live connection but after a few hours I still dont have it working. I have followed this:c https://powerbi.microsoft.com/en-us/blog/how-authenti...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Raoul

     

    As mentioned in your followed article:

     

    The email address that 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 your local Active Directory.

     

    So your Azure VM must be in a domain so that this authentication will work. See a similar thread below:

     

    https://community.powerbi.com/t5/Integrations-with-Files-and/Connecting-to-SSAS-tabular-model/td-p/79355

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

Raoul

 

As mentioned in your followed article:

 

The email address that 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 your local Active Directory.

 

So your Azure VM must be in a domain so that this authentication will work. See a similar thread below:

 

https://community.powerbi.com/t5/Integrations-with-Files-and/Connecting-to-SSAS-tabular-model/td-p/79355

 

Regards,