Forum Discussion

nmesmeric's avatar
nmesmeric
Frequent Visitor
6 years ago

SSAS Connection String: Anonymous Impersonation Level

Hey Guys,

 

I have an SSAS cube on premise and I am trying to connect from Power BI via an on prem data gateway.

 

To allow anonymous users access to the SSAS cube I need to specify the below in the connection string:

 

"Impersonation Level=Anonymous"

 

How can I add this to the connection string, I can't see anywhere where i can modify the connection string to SSAS?

 

Thanks,


Felix

 

Need Help

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    Hi there,

    When connecting to SSAS via the Gateway it would need to have an account which has got admin rights to the SSAS Server.

    Once that is done, as far as I am aware the impersonation would have to include a user account. You could map this user account via the gateway to a user account on your SSAS instance which would allow all users access.
  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi nmesmeric ,

    To setup SSAS anonymous authentication you need to complete 3 steps :

    • Change SSAS server property "Security\RequireClientAuthentication" value to False.
    • Edit your connection string and add following parameter: Impersonation Level=Anonymous;
    • Create SSAS database role and grant necessary permission to cubes and dimensions. Add user "NT Authority\Anonymous Logon" as a member of this role.

    After such setup any user should be able to access your SSAS database without authentication.

     

    The connection string is built using the information you provide in the Connection Manager dialog box. You can also view and edit the connection string in Management Studio in the data source property page.

     

    Refer this FAQ: How to setup SSAS anonymous authentication 

    About connection string:

    1. Data Source properties 
    2. Connection string properties 

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

    • nmesmeric's avatar
      nmesmeric
      Frequent Visitor
      6 years ago

      Hey v-yingjl,

       

      Thanks for your response.

       

      I have followed all instructions, however I have ended up with the same issue.

       

      When connecting to an on premise SSAS server from Power BI Cloud via a data gateway, I cannot see anywhere where I can specify an impersonation level in the connection string.

       

      Do you know where I can specifiy this? "Impersonation Level=Anonymous;"

       

      On the gateway the connection doesnt allow you to specify any aditional parameters, it only allows a server name and database name.

       

      Thanks for your help,

      Felix