Forum Discussion
SSAS Connection String: Anonymous Impersonation Level
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:
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.
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,
FelixHi nmesmeric ,
Please refer this document: Set Data Source Properties (SSAS Multidimensional)
After setting connection string, you need to map users in power bi service, refer this document: Map user names for Analysis Services data sources
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.