Forum Discussion

Chinoos's avatar
Chinoos
Icon for Helper I rankHelper I
10 years ago
Solved

Couldn't load the schema for the database model

The user get this error while accessing one Report on Power BI.com, but while accessing other report he's able to see data. By the way no RLS has been given. the source is Multi dimensional cube

 

 

Couldn't load the schema for the database model

You don't have permission to view this report because the owner has set row-level security (RLS) on the data model. Please contact the report owner.
Please try again later or contact support. If you contact support, please provide these details.

 

Activity ID136a053c-ba2e-481d-985e-490aca9faaab

TimeTue Aug 09 2016 15:11:35 GMT-0400 (Eastern Daylight Time)

Correlation IDeaa4855e-b205-149d-240a-302411625c4c

Version13.0.1500.566

Cluster URIhttps://wabi-us-north-central-redirect.analysis.windows.net

  • Hi Chinoos,

     

    When we run the report which connects to SSAS, the email address signed in the Power BI Service is considered as effective user, it will be passed to the gateway and onto SSAS server. If the email address doesn't match defined UPN within the local Active Directory Domain, the login will be failed.

     

    In your scenario, I would suggest you check if there is a match between Power BI Service signed in email address and your local directory UPN. For more information, please refer to this article: Usernames with Analysis Services.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

5 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    Hi Chinoos,

     

    When we run the report which connects to SSAS, the email address signed in the Power BI Service is considered as effective user, it will be passed to the gateway and onto SSAS server. If the email address doesn't match defined UPN within the local Active Directory Domain, the login will be failed.

     

    In your scenario, I would suggest you check if there is a match between Power BI Service signed in email address and your local directory UPN. For more information, please refer to this article: Usernames with Analysis Services.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

    • Chinoos's avatar
      Chinoos
      Icon for Helper I rankHelper I

      Thanks v-qiuyu-msft. Email address was given properly. But after the user restarted his sytem, it started working.

    • kchee's avatar
      kchee
      New Member

      I already setup the UPN but the issue same persist. My server in a workgroup with AD domain, is there anything elsee I need to set?

  • I tried this solution of rebooting and unfortunately continue to experience the same issue.  This is happenign for several users in my group on the Digital Stores Team and blocking us from compiling key monthly business reports.  Have any other solutions been mentioned/found?

  • I tried the posted solution and unfortuatnely am still unable to access several reports due to the reported Permissions Issue.  Have any additional solutions been proposed/found?