Reply
Member
Posts: 63
Registered: ‎05-31-2016

on-premises datagateway: problems with sync data

At this moment we have different powerbi-datasets which are refreshed by using a on-premises datagateway cluster with 2 servers. Some of the datasets don't refresh automatically. When we do it manually, we can refresh it. So my idea is that the configuration of the gateway is correct (in app.powerbi.com and on the server).

Sometimes, refresh it on another hour can already give a solution. But not always.

 

 

How can we get more information about this problem? How can we debug it?

Can it be some time-out? Can it be a problem with network capacity? capacity of our internet connection?

 

Thanks in advance for any idea.

 

Community Support Team
Posts: 7,652
Registered: ‎05-02-2017

Re: on-premises datagateway: problems with sync data

Hi @eddydm,

 

1. Did you set the scheduled refresh?

2. Can you find something in the refresh history?

3. The scheduled refresh may delay for a while. Please refer to refresh-scheduled-refresh#schedule-refresh.

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Member
Posts: 63
Registered: ‎05-31-2016

Re: on-premises datagateway: problems with sync data

Scheduled refresh is set.

 

In the history I found the dutch message 'Uw gegevensgateway is offline of niet bereikbaar'

which means that our gateway is offline or not reachable.

We have a gateway cluster with 2 servers which should be used randomly.

 

How can we test ourselves if our gateway is online and reachable?

Community Support Team
Posts: 7,652
Registered: ‎05-02-2017

Re: on-premises datagateway: problems with sync data

Hi @eddydm,

 

You can test the data sources in the Gateway settings. Please refer to the snapshot below.

on-premises-datagateway-problems-with-sync-data

Or you can log in the servers that host Gateways and open the Gateway to see its status.

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Posts: 7,652
Registered: ‎05-02-2017

Re: on-premises datagateway: problems with sync data

Hi @eddydm,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member
Posts: 63
Registered: ‎05-31-2016

Re: on-premises datagateway: problems with sync data

Not yet solved.

 

Colleque found on Microsoft support page that 'some users in North Europe may experience intermittent scheduled refresh failues and receive a "Your data gateway is offline or couldn't be reached" error. Engineeers are working on a fix and will provide an ETA soon.