Forum Discussion

Marcin's avatar
Marcin
Helper V
8 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    rgparisoto
    Helper I
    7 years ago

    Hi Anonymous !

     

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

     

    Tryed lots of alternatives.