Forum Discussion
Connection to Azure Analysis Services Issue
Hi,
we had this problem in our organization. that we can't view any report connected to tabular model on Azure Analysis Services with live connection mode, we get an error : ( only on Web portal )
We are able to connect to model from PowerBI desktop app without any problem, also other report connected to other data sources works fine , only this one has this problem.
I tried to re-deploy model from Visual Studio, pause and start Azure Analysis Services but it didn't solve the issue.
8 Replies
Additional error info:
Marcin did you get a resolution to this issue? I've just run up against this problem myself. The reports work for me, but others get that error message in your post. My gut feeling is that it is a permissions issue. I've tried adding 'read-only' permissions at the AAS level as well, but it hasn't worked so far. I'm holding out hope that it takes time to propagate.
I have some deadlines and wasn't expecting this to be an issue, so i'm hoping to come across a solution. My expectation is that it will be something straight forward, but its all about discovering what this small item is.
Ok I know the problem and how to solve it. When you create the model you also need to add a Read-Only role into the data model for the users to access. I had difficulty doing this with Visual Studio, as it wouldn't accept my email address and security groups. I made use of SQL Server Management Tools and created roles and access through there. This resolved the problem. Details can be found here:
https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-database-users
Hi Anonymous !
I can't find a solution to make my PBI works on-line.
Tryed lots of alternatives.
