Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Using adirect query to connect SQL Server. Everything is good until refreshed using on-premise gateway.
Can anyone provide any suggestion?
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
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
@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
Thanks for your info. I will start from here 🙂
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
35 | |
32 | |
19 | |
12 | |
8 |
User | Count |
---|---|
52 | |
37 | |
29 | |
14 | |
12 |