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.

     

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.