Forum Discussion

Anonymous

Not applicable

9 years ago

Solved

SSAS Connection Fail

Hello.

I have a liveconnect dataset to SSAS.

I have an on-premises dataway wiht an SSAS connection.

In PowerBI desktop the dashboard works property, but when I publish it and I assign the gateway appear a error (I attach the images).

Can someone help me?

Anonymous
9 years ago
Hi Anonymous，

Could you please tell us what is your local directory UPN and the email address that you use to sign in Power BI？ If the local directory UPN doesn't match that email address, you would need to configure a mapping rule to have local directory UPN passed to Analysis Services according to the instructions in the Map user names section of this article.

Thanks,
Lydia Zhang

8 Replies

Anonymous
Not applicable
9 years ago
Hi Anonymous,

Could you please translate the above error message to English?

If you get the error message like” Couldn't load the schema for the database model”, please check that if the email address that you sign into Power BI service matches the defined UPN within the local Active Directory Domain following the instructions in this article.

If your Power BI service login names do not match your local directory UPN, you can use the Map user names feature to create UPN mappings for Analysis Services Live connections that go through the on-premises gateway for Power BI.

Thanks,
Lydia Zhang
- Anonymous
  Not applicable
  9 years ago
  Hello Lydia.
  Thank you for your response.
  Actually the message i got is " Couldn't load the schema for the database model”.
  The point is that we connect to an Internet Information Server (and here connect to SSAS with a fixed user).
  I hope that you can help me.
  - Anonymous
    Not applicable
    9 years ago
    Hi Anonymous,
    
    Have you check that if the email address that you sign into Power BI service matches the defined UPN within the local Active Directory Domain?
    
    Thanks,
    Lydia Zhang