Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
31 | |
28 | |
23 | |
20 | |
16 |
User | Count |
---|---|
55 | |
38 | |
28 | |
24 | |
22 |