Forum Discussion
Cannot connect to Azure Analysis Service model using non administrator user account
Hi everyone,
I've manage succesfully connect live to our Azure Analysis Servicemodel and report is working after publishing to power bi service. The problem is that when other users (which have access to this report and don't have administrator role on Azure Analysis Service) cannot access the report because power bi cannot connect to model when they are accessing report. From my account or other users with admin privileges everything is fine. How to fix this behaviour?
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.
5 Replies
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-usersCan 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.
