Forum Discussion

srinival's avatar
srinival
Icon for Helper I rankHelper I
6 years ago

Power Bi Gateway - Errors

Hi Team,   We have installed On Premise Data Gateway software, which is used to use the data source from Microsoft SQL Server and publish the information in Power Bi Service.   It was working til...
Need Help
Tips and Tricks
Tutorial Requests
Nimai123's avatar
Nimai123
Icon for Post Patron rankPost Patron
6 years ago

Hello srinival 

 

I have faced this same issue a few months back.

 

You can try doing this hope it helps!

  • Increase the time of the Query in Advanced Editor.
  • Update the Gateway.
  • Re-configure the Gateway.
  • Do not run many refreshes at the same time because then the load increases on the SQL server.
  • Raise a support ticket which is free if you are a PRO user, they will help you to get the logs and help you to understand the source of error so that we can work on the right direction. 

2 point was my solution.

 

As per my experience, your SQL is taking time to respond due to the 4 point, do check if possible SQL error logs.

 

If you like my solution give it a Kudos!

And if it solves your problem accept it as a solution.

 

Regards,