Forum Discussion

Ving's avatar
Ving
Frequent Visitor
8 years ago
Solved

PBI Desktop could not connect to SSAS

Hello everyone,  I am facing with the following issue last few days. I am newbie in PBI and I need your help. I have SSAS installed in the Domain Controller and I am trying to create a connection fr...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Ving,


    Current power bi desktop only support to use windows authorizations to connect to SSAS data source(when you use default connector), if current account is different than your ad account, it is impossible to connect to SSAS data source.


    Please use valid account, ask database admin to give permissions for current account or use other connector to access SSAS datasource.

    OLAP, Analysis Services connection strings

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Ving,

 

I think you are misunderstood with data gateway, it is used to handling data source and publish data to power bi service.

It not works when you are get data on power bi desktop. For your scenario, I think you need to setup proxy/vpn to access that data source.

 

Regards,

Xiaoxin Sheng

Ving's avatar
Ving
Frequent Visitor
8 years ago

Hello Anonymous,

Thank you for your reply! I will give you more details how the whole architecture is configured. Enterprise Gateway has a Data Source which is poiting to SSAS. The user who is autenticating from data source in front of the SSAS is a admin and also persist in the SSAS as admin. When I run the PBI desktop from the cmd with /netonly /user:AD\user I established a successful connection to the SSAS. When I run PBI Desktop from my desktop icon, I cannot connect to the SSAS. Even I am authenticate with my AD\user and password. I am using a VPN to access SSAS. The following error occured when I am trying to connect to SSAS:

  

 

I think I am missing something in the configuration of the enterprise gateway or may be somewhere else. If you have any ideas how to resolve the issue it will be great! 

 

Best Regards, 

Ving

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Ving,


    Current power bi desktop only support to use windows authorizations to connect to SSAS data source(when you use default connector), if current account is different than your ad account, it is impossible to connect to SSAS data source.


    Please use valid account, ask database admin to give permissions for current account or use other connector to access SSAS datasource.

    OLAP, Analysis Services connection strings

     

    Regards,

    Xiaoxin Sheng