Forum Discussion

smpa01's avatar
smpa01
Community Champion
2 years ago

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.           ...
Data Engineering
smpa01's avatar
smpa01
Community Champion
2 years ago

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.

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

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.

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi smpa01 

     

    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
    In case if you have any resolution please do share that same with the community as it can be helpful to others.
    Otherwise, will respond back with the more details and we will try to help.

    Thanks

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee
      2 years ago

      Hi smpa01 

      Could you please confirm couple of things.

      Have you opened up the required 1433 ports for the data gateway?

      Did you map the connection to a single gateway? You can't use multiple gateways in a single solution.

      For more details on 1433 port please refer Link. 

       

      Thanks.

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Microsoft Employee
        2 years ago

        Hi smpa01 

         

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
        In case if you have any resolution please do share that same with the community as it can be helpful to others.
        Otherwise, will respond back with the more details and we will try to help.

         

        Thanks