Unable to refresh data for reports based on on-premise database (Gateway not working)

[nirman]

Hi,

I have created some reports which are referencing to the on-premise SQL Server database via Power BI gateway. I have created a refresh schedule for all these reports.

The reports were refreshing correctly till recently, but somehow the reports are now not refreshing now. I tried to investigate for the issue, and as a first step I verified and confirmed Gateway was still up and running. But when I tried to check the refresh schedule of the reports, I found the controls in "Gateway Connection" tab are stuck and not responding. This is happening for all existing reports, as well as I tried creating a new report and still it was showing the same. It doesn't proceed even after waiting for half an hour.

Please see the screenshot.

Could you please assist as early as possible?

Thanks

Nirman

[nirman]

Any idea or help on this issue? This issue makes the product of no use for us honestly. We are unable to refresh (manual as well as scheduled) any report at all.!!!

[kcantor · Accepted solution]

Uninstall and reinstall the gateway. I had to do this before. Be sure you remove it from the control panel completely before reinstallation.

[nirman]

Strange! but this worked. Earlier, I upgraded the Power BI gateway which didn't work. Un-installing and re-installing did the trick. Thanks kcantor.

[Anonymous]

You could try restarting the server/service where the gateway is installed.