Forum Discussion

cnormand127's avatar
cnormand127
Regular Visitor
9 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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,

  • cnormand127's avatar
    cnormand127
    Regular Visitor
    9 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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,

      • cnormand127's avatar
        cnormand127
        Regular Visitor
        9 years ago

        In powerBI online, when you select a dataset and go to settings, You select gateway, you have two choices:

        - Use Your Data Gateway (Power BI - Personal)

        - Use a Data Gateway

        I selected the second one, not the first one. Then if I go to Settings > Manage Gateway. The SQL Server gateway fails and the error message is : 

        Cluster URI: https://wabi-us-east2-redirect.analysis.windows.net
        Status code: 400
        Error Code: DM_GWPipeline_Gateway_CancellationOrTimeoutError
        Time: Wed Jul 05 2017 11:10:55 GMT-0400 (Eastern Daylight Time)
        Version: 13.0.1781.239

        My reports couldn't refresh for the last 5 days and it's happening a lot....