Reply
Frequent Visitor
Posts: 4
Registered: ‎04-05-2017

Scheduled refresh breaking with VPN secured on-premise SQL Database table

[ Edited ]

I have a Power BI Service pointing to an on-premise SQL Server Database table that belongs to a secured VLAN where I need VPN credentials to access. I have built and Enterprise Gateway to play as a bridge to the on-premise server and secure the data trasnfered. If I setup a scheduled refresh of the report in Power BI Service, and I'm in the office connected to the corporate network, everything runs smoothly. As soon as I leave the office, and my surface is not connected to the VPN, the Schedule Refresh crashes...

 

I have installed the On-premise gateway in my local machine, not in the on-premise server, that might be a valid reason to crash, isn't it?

 

Am I missing something?

 

I'm using my windows credentials hard-coded in the data source.

 

Thanks for you time!

Data analytics supporter !
Senior Member
Posts: 395
Registered: ‎06-24-2015

Re: Scheduled refresh breaking with VPN secured on-premise SQL Database table

hi @biswedishdevil

 

The scenario you described is exactly what I would expect to happen.


I would assume that as soon as you are off your network, which also means you are no longer connected using the VPN, the Gateway can no longer get the required access to the SQL Database. And when that happens the Refresh will fail.

 

I would suggest if possible to install and configure the Gateway to run on a server inside your network. This would then mean the VPN is no longer required. As well as then the refreshing would happen as per the schedule.

Twitter: @guavaq
Highlighted
Frequent Visitor
Posts: 4
Registered: ‎04-05-2017

Re: Scheduled refresh breaking with VPN secured on-premise SQL Database table

I will try as soon as I get to the office! Thanks in advance!
Data analytics supporter !