Forum Discussion

Jalalmn's avatar
Jalalmn
Frequent Visitor
2 years ago
Solved

error on MSSQL database import with dataflow gen2

Hi,   I have received a SQL Server connection using username and password (and server) and want to use it in fabric dataflow gen2. The connection works on azure data studio and even power BI deskt...
Dataflows
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Jalalmn ,

    As I said above, SQL Server is an on-premises data source that requires a gateway to upload to Fabric Data Factory.

    If you select SQL Server instead of gateway, the above error will occur.

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Jalalmn ,

I also create a SQL Server as you mentioned.

Then I select SQL Server database in Data flow Gen2.

When I choose not to use the gateway connection during the connection process, the same warning will be returned as you.

So I think you should choose the gateway correctly and make sure that the gateway is configured correctly.

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Jalalmn's avatar
Jalalmn
Frequent Visitor
2 years ago

Thank you so much for your quick reply ðŸ™‚

 

You mean regarding the context there is no way to make the connection work directly (without gateway)?

 

Best,

Jalal

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Jalalmn ,

    As I said above, SQL Server is an on-premises data source that requires a gateway to upload to Fabric Data Factory.

    If you select SQL Server instead of gateway, the above error will occur.

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.