Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      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?

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee

        Hi Anonymous,

         

        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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Anonymous,

     

    Could you please mark the proper answers as solutions?

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable

      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.