Forum Discussion
Cannot connect to Azure Analysis Service model using non administrator user account
Ok we found out where is the problem - Roles in AAS works a little bit different comparing to Power BI and it not only filter data but determine what permissions are granted to mentioned members, so we only added new members to existing in our case role in AAS model using SSMS.
Hi! casto_jm
What roles does a user have on AAS and do you see any errors? Can you share the error details?
Unfortunately I have only message in polish but I can translate it for you:
Cannot connect to data model
We cannot open report, because Power BI service cannot establish connection to data model in Azure Analysis Services. Check if you are using correct credentials and contact with data model owner or Azure Analysis Services administrator to make sure that data model is available.
Try again later or contact with technical support. If you contact with technical support, provide these details.
In terms of roles, user which couldn't connect to data model doesn't had any rights, we tried with admin role and it worked, then we switched to contributor and stopped working. We found out in microsoft documentation that user connecting to model has to have admin rights but we didn't think that this applies to every user.
https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-manage-users
Can you try Owner permission instead of Admin. Also, I would advice if you have multiple users, then create an AD group and add the required users to that group and provide access at one go.
Owner role doesn't work with or without a group. I think it's worth mentioning that it's only working when user is added as admin but in only in Analysis Services Admins
Ok we found out where is the problem - Roles in AAS works a little bit different comparing to Power BI and it not only filter data but determine what permissions are granted to mentioned members, so we only added new members to existing in our case role in AAS model using SSMS.