Connection to Azure Analysis Services Issue

[Marcin]

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. 

[Anonymous]

@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.

[Anonymous]

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

[rgparisoto]

Hi @Anonymous !

I can't find a solution to make my PBI works on-line.

Tryed lots of alternatives.

[Marcin]

Additional error info:

[deepu299]

@Marcin Hi, If it is working fine with desktop and the issue is only with Service, the issue will be with Gateway. Please check the logs on Gateway server and check the permissions on the related data source. 

[Marcin]

Hi @deepu299,

what Gateway exactly do you mean ? 

I am not using any Gateway because I am connected to Azure Analysis Services not on - premise SSAS.

[deepu299]

@Marcin You are correct, My bad. I use On-Prem SSAS and this error is mostly observed due to gateway issues. Some times due to unavailability, some times due to permissions that the user who runs is not able to access the model. Do you need to grant any such permissions to connect ? 

[Anonymous]

If you are using on prem SSAS,  make sure that the user assigned to the report is granted access to the SSAS instance also