Forum Discussion
On-prem Gateway issue
I am trying to utilize DFGen2 to query a sql table accessible via on-prem Gateway and publish the result to a LakeHouse Table.
I am running into following errors.
I can use a dataflow in power bi using same gateway without having any issues whatsoever.
How can I resolve this?
8 Replies
Hi smpa01
Thanks for using Microsoft Fabric Community.
Apologies for the issue that you are facing.
As I understand that you are trying to utilize DFGen2 to query a sql table accessible via on-prem Gateway and publish the result to a LakeHouse Table.
The below procedure might help you to resolve your ask.
In order to connect from on-prem SQL server to Fabric, you need to install an on-premises gateway. Please find the related documentation - Install and configure an on-premises data gateway
For server connection from on-prem SQL server to Microsoft Fabric please refer :
On Premise SQL Server 2022 Data into Microsoft Fabric
Getting On-Premises SQL Server Data to Fabric Lakehouse
I hope this information is helpful. If problem still persists please do let us know.
v-cboorla-msft on-prem gateway is already installed as I am using the same gateway to create dataflow in Power BI ( as opposed to DFG2 in Data Engineering ) without any issue and able to refresh and consume the same dataflow downstream.
Hi smpa01
Could you please confirm the present version of your on-Premises gateway? If you are running on the older version try to upgrade to the latest version, this might help me you in resolving the error.
For details please refer Link.
I hope this helps. If you have any further queries please do let us know.
