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

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.

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

      Thank you very very very much.

      It works.