Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Azure Analysis Services - Unable to connect to the data model

Hello all,

 

I have a PowerBI report with an Azure Analysis Services connection. All users are able to access the report without issues, except for one person which has the following message when trying to access:

  

 

This user has permissions in both Power BI and Analysis Services as a Viewer.

 

What else could cause this error message?

Need Help

4 Replies

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    DOes this one user have the right role or in the right group?  As per this article - https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-database-users

     

    Or, does that person have a new enough version of Power BI?  Or, are they using the right userid in the first place when trying to access the report?

     

    I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi collinq and Anonymous ,

       

      Yes the user has a Read role on Analysis Services and Viewer role on Power BI.

       

      The user name matches on both sides as we're using O365 for user management, so I don't think that's the problem. 

       

      If the user changed password, could this cause an authentication error that locks them from viewing the data?

       

      Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous,

        Yes, it might be a reason that power bi failed to verify credentials. (e.g. changes on password, permission, user role group, etc...) Please also check your credential permissions and correspond role settings and update your credential on power bi service side.
        Notice: if you enable security settings on the AS database side, please double check to confirm it not the object level security.
        AFAIK, current power bi only supports row-level security, object-level security not compatible with power bi, they may cause some other issues.

        Regards,

        Xiaoxin Sheng