what caused this? data refresh take very long time

[Anonymous]

It takes very long time and there is a situation like this, the gateway runs on on server, the server works well, what caused this?

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

It seems that you need to restart the gateway. 

1. Input "services.msc" in the search box. (or use Win + r in keyboard)
2. Restart the service as showed in the picture or start it if it stopped.
3. If step 1 and 2 failed, restart the computer and then check the status of the service.
4. There is an official trouble shooting document, you can reference: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-tshoot/ 
5. Last try: uninstall gateway -> restart computer -> install the newest version. (Please consider the down time if it's a production machine.)

After all, upgrading to the latest version  is recommended.

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-update

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Make sure Gateway is up and running and logged in. Check Are using the service login of your login in the gateway? This usually with running and login

refer if required

Troubleshoot gateway
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKk