Scheduled refresh breaking when using gateway on SQL database with VPN

[Anonymous]

I have a gateway installed on the on-premise server (SQL) but everytime my scheduled refreshes fail. I have no idea why...

When I connect to my SQL database locally I need a VPN. Could that be the problem?

This is my gateway:

And this is the message I get:

Technical Information:

Activity Id: ffc10710-c30a-4a69-90b7-45fdf5db7ecc

Request Id: e8f4ac6e-7f04-418d-82f2-af4589c77105

Cluster Name: WABI-NORTH-EUROPE-redirect.analysis.windows.net

Refresh Start Time: 11/11/2017 20:01:36Z

Refresh End Time: 11/11/2017 20:17:17Z

What do I do wrong?

[v-yuezhe-msft]

@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]

@v-yuezhe-msft

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

[v-yuezhe-msft]

@Anonymous,

Does the server that install gateway is always on? Do you see any error message in Refresh History?

Regards,
Lydia

[Anonymous]

@v-yuezhe-msft,

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-b2b999b54835

Request Id: c920d547-e12a-4ab2-9c45-ad46ce258c52

Cluster Name: WABI-NORTH-EUROPE-redirect.analysis.windows.net

Refresh Start Time: 11/15/2017 16:01:39Z

Refresh End Time: 11/15/2017 16:23:33Z

[Anonymous]

And sometimes I see this warning:

Cannot connect to the mashup data source.

[v-yuezhe-msft · Accepted solution]

@Anonymous,

I would recommend you open a support ticket on the support.powerbi.com site.

Regards,
Lydia