Forum Discussion

nirman's avatar
nirman
Advocate IV
10 years ago
Solved

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

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

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

4 Replies

  • 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's avatar
      kcantor
      Community Champion

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

      • nirman's avatar
        nirman
        Advocate IV

        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's avatar
      Anonymous
      Not applicable

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