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...
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.... 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      cnormand127,

      Could you please restart the On-Premise gateway Services?

      Also 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.

      Regards,

      • cnormand127's avatar
        cnormand127
        Regular Visitor
        9 years ago

        I did restart the gateway service but it doesn't change anything. the only way for me to update the online reports is to open PowerBI Desktop, refresh the dataset and publish again....

        What I don't understand is that in the gateway setting of the dataset, it seems that the data are pulled from my SQL server directly and are not going thru my local personal gateway (see image below)

         

        I thought only the first radio button would force it to use the local gateway but from what I understand, the second one  (Use a Data gateway) was a direct connection (created in Settings > Manage Gateway)