Forum Discussion

Anonymous's avatar
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 ...
Need Help
  • Anonymous's avatar
    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

Anonymous's avatar
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's avatar
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Yes I checked that.

    Anyway the the user I thin that doesn´t matter because finally the user than connect to ssas is of the local domain.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Anonymous，

      If the email address does not match a UPN within your local directory, the report will fail. What is the rsult after you check the UPN? I would also recommend you run SQL Server Profiler to capture more information.

      Thanks,
      Lydia Zhang

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hello Lydia.

        I have used the profiler and the user that is used I think is correct (mts domain).

        In the gateway test, the connections works, also I can connect with this user through Management Studio.

        I attach images.