Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
Solved! Go to Solution.
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
29 | |
17 | |
13 | |
8 |
User | Count |
---|---|
48 | |
39 | |
33 | |
17 | |
16 |