Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Trouble adding Analysis Services credentials to On-Premises Data Gateway for Service Account

I'm trying to connect to an Analysis Services database in Power BI Service. When trying to connect live directly in the service, it says the connection method is being deprecated. Trying to publish the desktop file instead, it won't let me add credentials to the gateway. I'm trying to use a service account, which can access the Analysis Services database in SSMS successfully. This is the error message that I am getting when trying to add the data source in the gateway:

 

Need Help

8 Replies

  • nitishsh91's avatar
    nitishsh91
    Solution Supplier
    4 years ago

    Hi Anonymous 

     

    Please check if you are able to connect to this SSAS server from the gateway server, try doing telnet(connectivity test) first to ensure the connectivity is there.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      If the gateway is installed on a physical desktop, and that desktop is able to connect to the SSAS database in SSMS, does that mean the connection is open?

      • nitishsh91's avatar
        nitishsh91
        Solution Supplier
        4 years ago

        Yes, does your desktop id by which you are logged in has got access on SSAS server?