Forum Discussion
VPN data load issue
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
Community ChampionYou will need to work with your IT department to properly set the VPN settings to allow your access to your data warehouse. It is blocking something, or multiple somethings. But every data server can be configured in multiple ways, so your IT or DBA is the best place to start.
So in theory it should work when I am connected with a VPN right?
- edhans
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.