Forum Discussion
Scheduled refresh breaking when using gateway on SQL database with VPN
Anonymous,
I would recommend you open a support ticket on the support.powerbi.com site.
Regards,
Lydia
Anonymous,
To make the refresh process smooth, please make sure that the on-premises gateway has access to your SQL database. In your scenario, are you able to connect to the SQL Server database from other applications such as SSMS and Excel which are located at the server that has gateway installed?
In addition, the computer that installed gateway should be always turned on and connected to the Internet, otherwise, refresh may fail.
Regards,
Lydia
Anonymous
The SQL server is hosted on an internal network on Azure. The SQL server can only be reached via VPN, however the SQL server does have an outgoing connection to the Internet. The On Prem Gateway can connect to PowerBI.
The On Prem gatway is installed on the SQL server so it has always access to the database.
I expect that when my laptop is switched off the datarefresh would work but unfortunately it only refreshes when my laptop is on with my VPN connected.
Thanks for your response,
Wieke
Anonymous,
Does the server that install gateway is always on? Do you see any error message in Refresh History?
Regards,
LydiaAnonymous,
All my refreshes fail when my laptop is not connected to VPN. It seems strange because I think I'm using a gateway that is independent of my laptop....
This was the message I got:
Technical Information:Activity Id: 7fe4b257-f0ae-4fbc-907a-b2b999b54835Request Id: c920d547-e12a-4ab2-9c45-ad46ce258c52Cluster Name: WABI-NORTH-EUROPE-redirect.analysis.windows.netRefresh Start Time: 11/15/2017 16:01:39ZRefresh End Time: 11/15/2017 16:23:33ZAnd sometimes I see this warning:
Cannot connect to the mashup data source.