error on MSSQL database import with dataflow gen2

[Jalalmn]

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 desktop. But on dataflow gen2, it returns an error:

The connection could not be established. Access may not be possible via this network or via this URI, or a gateway may be required to access this data source.

I have played with different server with port and without port settings, but it does not work.

Would appreciate your help!

Best,

Jalal

[Anonymous]

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]

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 · Accepted solution]

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.