Forum Discussion

inm's avatar
inm
Helper II
5 years ago

Get data from analysis service when the server is not on premises

I have the sever's name, username and password. I can access the data through the connection in excel, but from power bi it requires that it be on premises. Is there a way to get connected in this case?

 

I appreciate any help in advance.

Interesting Links
Tutorial Requests

6 Replies

  • edhans's avatar
    edhans
    Community Champion
    5 years ago

    How are you getting access via Excel? As long as you have a login and some type of network connection, like a VPN or accessing a cloud based server, it will work. 

    I am wondering if you are accessing in Excel via a proprietary addin via the vendor vs the Get Data tool in the Data ribbon.

    • inm's avatar
      inm
      Helper II
      5 years ago

      I am not accessing through vpn, I only change the type of login to username and password and it works, but power bi doesn't let me do this, it requires that it be on the same network so I don't know how to do it.

       

      Thank you for your answer.

      • edhans's avatar
        edhans
        Community Champion
        5 years ago

        So you are telling me in Excel, you go to the Data tab, click Get Data, From Database, From Analysis Service, and you can type in the login info there, but in Power BI, if you go to Get Data, click on SQL Server Analysis Services Database and enter the same credentials there, it doesn't work? Because it is pretty much the same connector, it just looks a bit different.