cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eddydm Helper III
Helper III

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.

 

5 REPLIES 5
Microsoft
Microsoft

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.
eddydm Helper III
Helper III

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?

Highlighted
Microsoft
Microsoft

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.
Microsoft
Microsoft

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.
eddydm Helper III
Helper III

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.

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.