Forum Discussion

nelson777's avatar
nelson777
Frequent Visitor
4 years ago
Solved

OnPrem Server Reports not Refreshing

Hope someone can help with this scenario

 

- Gateway installed and fully functioning.

- SQL Server Datasource connection working with no issues

- Refresh either manual or scheduled, not working.

 

 

 

 

 

Need Help
  • nitishsh91's avatar
    nitishsh91
    4 years ago

    Hi nelson777 

     

    This is sql server side error, first point to check is to look at SQL server error logs around that time to try and relate the issue. 

    Also try restarting the On-Premises gateway service and also SQL service to see if that helps.

    Also try loading one simple table in PowerBI and see if that works, it might be that its happening for just one table.

3 Replies

  • nitishsh91's avatar
    nitishsh91
    Solution Supplier
    4 years ago

    Hi nelson777 

     

    This is sql server side error, first point to check is to look at SQL server error logs around that time to try and relate the issue. 

    Also try restarting the On-Premises gateway service and also SQL service to see if that helps.

    Also try loading one simple table in PowerBI and see if that works, it might be that its happening for just one table.

    • nelson777's avatar
      nelson777
      Frequent Visitor
      4 years ago

      Hi Nitish,

       

      Thanks for the word of advice. 

      I did try just one query and it was working.

      So, apparently, the issue was related to the other queries structures, which even though they were working on the PBI desktop, they weren't on the PBI Service.

      Once queries were "fixed", refreshing started to work normally.