Forum Discussion

jofoster's avatar
jofoster
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Connect to SQL analysis services on powerbi service issues

Up to this point, I have successfully avoided dealing with gateways.  However, I am trying to connect to SQL Analysis services and failing miserably.  I am able to connect in PowerBI Desktop, but when I publish to the cloud, it fails around gateways.  I have installed a "personal" gateway, but it seems more is required.   I am being lead down a path to connect a data source to my gateway, but that fails. And I am not even sure it is a correct path.

 

I have uploaded some photos on the UX I am seeing. Appreciate any help

 

 

 

 

 

Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    7 years ago
    Hi there

    When you are connecting to an On-Premise SSAS Database it can only authenticate via a domain account. There is no such concept as a standard user account.

    You will need to ensure that you have a domain account, and that the domain account is part of the servers Security Group.

    The format of the domain is: DomainName\UserName
    EG: FourMoo\GilbertQue
  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi jofoster ,

     

    Firstly ensure that your SSAS server and gateway are installed in a same domain or trusted domains.

    Secondly, in Power BI,  the effective username is passed to the gateway and then onto your on-premises Analysis Services server each time a user interacts a report connected to Analysis Services. The email address that you use to sign in Power BI with is passed to Analysis Services as the effective user. This email address should match a defined UPN within the local Active Directory Domain, if a match cannot be found, you will get errors.

    You can use the following command from your workstation to find out the UPN for your account, if the UPN doesn't match the email address you sign into Power BI with, you can use “Map user names” feature to solve this issue.  Assume that you if you sign into Power BI with [email protected], but your local directory UPN is [email protected], you can configure a mapping rule to have [email protected] passed to Analysis Services. For more details, please review this article.

     

    whoami /upn

     

    Best regards,

    Dina Ye