Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

VPN data load issue

I have been trying to load data from the warehouse remotely and have been unsuccessful. I spent the weekend getting my vpn connection working properly and I have tested the VPN connection by using mi...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi jaromgleed,

     

    Which kind of data warehouse are you trying to connect to? If you want to connect to database like sql server, you can connect to your server with power bi desktop if only you can connect to your server with SSMS. If you are going to connect to database like SSAS,firstly your server should be in the company domain, secondly the database admin should add your domain account in the instance.

     

    Regards,

    Jimmy Tao

Anonymous's avatar
Anonymous
Not applicable
7 years ago

So in theory it should work when I am connected with a VPN right? 

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
7 years ago
Anonymous wrote:

So in theory it should work when I am connected with a VPN right? 

Yes. It is just a matter of making sure the right firewall ports are open on your server to allow VPN traffic through, and that your VPN is passing the correct data from your machine to the server you need. You can have half a dozen different configuration issues with SQL Server alone. SQL Server straight databases vs SSAS have different ports they use, different permissions, firewall settings, etc. It just goes up from there.

 

Your IT team and DBA if you have one are the best ones to assist with this.