Forum Discussion
SQL Server Data Gateway Offline
Hi,
We have been having that issue for a long time now. We have setupa data gateway in power BI that links to our SQL server (no personal) and 50% of the time the gateway status is set to offline so scheduled refresh fail to execute.
This is the error message detail:
Status code: 400
Error Code: DM_GWPipeline_Gateway_CancellationOrTimeoutError
Time: Mon Jul 03 2017 10:56:37 GMT-0400 (Eastern Daylight Time)
Version: 13.0.1781.239
Thank you,Our SQL server is live and there is no problem to connect to it. Could someone please let me know why are those gateway are offline and what can be done to have them online at all times? Also is there any support provided by Microsoft regarding powerbi? The forum are the only place I could find to ask for help....
Chris
16 Replies
cnormand127,
Firstly, please make sure that you installed the gateway on a computer that is always turned on and connected to the Internet. And please check if there are any issues about the network between the machine that installed gateway and the machine that installed SQL Server.
Secondly, go to Services and restart your gateway service.
Thirdly, do you use "import" mode to connect to SQL Server in Power BI Desktop? Do you import large amount data from SQL Server and define a complex data model in Power BI?
Regards,Hi Thanks you for your response. I do not use my own gateway (PowerBI - Personal) but I use a direct Data gateway to our SQL server. I thought this wouldn't go thru my desktop data gateway, would it?
In regards to PowerBI Desktop, yes, I use Import. Our queries are not that complex and can return up to 500,000 records. Should I use DirectQuery?
Thank you,
Chris
cnormand127,
What do you mean by "direct data gateway"? Do you mean "On-premise gateway"? And what do you mean by "desktop data gateway"?
Besides, your dataset is not large, you don't need to use DirectQuery.
Regards,
