on-premise gateway problem: Couldn't load the data for this visual

[Anonymous]

 Using adirect query to connect SQL Server. Everything is good until refreshed using on-premise gateway.

Can anyone provide any suggestion?

[v-qiuyu-msft]

Hi @Anonymous,

Please go to Dataset Settings, check which gateway used by that dataset, make sure data gateway is online. Also please update the data gateway to the latest version.

Best Regards,
Qiuyun Yu

[Anonymous]

Hi @v-qiuyu-msft, how do i check if my gateway is the latest version?

Many thanks,
JS

[v-qiuyu-msft]

Hi @Anonymous,

You can check installed data gateway version from Control Panel. The latest version is 14.16.6355.2. You can download latest version from here.

Best Regards,
Qiuyun Yu

[Seth_C_Bauer]

@Anonymous Are you writing scripts, or just accessing tables? Looks like it is having an issue with a data type/relationship or join. The error is a pretty good pointer, but you may be able to get some more detail from the gateway error log files. Those are located waaay at the bottom of the troubleshooting guide - here

Installer logs

%localappdata%\Temp\On-premises_data_gateway_*.log

Configuration logs

%localappdata%\Microsoft\on-premises data gateway\GatewayConfigurator*.log

On-premises data gateway service logs

C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log

[Anonymous]

Thanks for your info. I will start from here 🙂