Forum Discussion
SQL Server Data Gateway Offline
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,
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....
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,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)
cnormand127,
Do you use tha latest version of on-premises gateway? How about you install personal gateway and use it to refresh your dataset?
Regards,