topic error on MSSQL database import with dataflow gen2 in Dataflow

error on MSSQL database import with dataflow gen2

Jalalmn — Wed, 24 Jul 2024 16:05:13 GMT

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

Re: error on MSSQL database import with dataflow gen2

Anonymous — Thu, 25 Jul 2024 03:10:58 GMT

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.

Re: error on MSSQL database import with dataflow gen2

Jalalmn — Thu, 25 Jul 2024 07:43:51 GMT

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

Re: error on MSSQL database import with dataflow gen2

Anonymous — Thu, 25 Jul 2024 08:39:16 GMT

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.