topic Re: MS Fabric connection to MS SQL on-premise data with dataflow gen2 in Dataflow

MS Fabric connection to MS SQL on-premise data with dataflow gen2

marius1106 — Tue, 09 Apr 2024 11:49:07 GMT

I have some data in a database in MS SQL on-premise and want to load them to MS Fabric. I tried it with a dataflow gen2 and a gateway for the on-premise data. The connection to the datasource in my dataflow worked, but when I want to write my data to a lakehouse it can't open my destination-lakehouse (shown in screenshot). (A colleague has the same problem when he tries it)

Did I something wrong in the connection-settings or is it currently not possible to connect to an on-premise MS SQL database? Is there a workaround?

Thank you,

Marius

Re: MS Fabric connection to MS SQL on-premise data with dataflow gen2

MOVC — Tue, 09 Apr 2024 15:17:31 GMT

Doesn't the Lakehouse have to be in the same workspace as the Gen2 Dataflow? It looks like you've made the dataflow in My Workspace.

Re: MS Fabric connection to MS SQL on-premise data with dataflow gen2

marius1106 — Tue, 09 Apr 2024 15:24:37 GMT

The dataflow and the lakehouse is both in "my workspace"

Re: MS Fabric connection to MS SQL on-premise data with dataflow gen2

MOVC — Tue, 09 Apr 2024 15:29:23 GMT

Apologies, I must have misread the screenshot. I would just try doing this in a regular premium or trial capacity workspace instead.

Re: MS Fabric connection to MS SQL on-premise data with dataflow gen2

miguel — Tue, 09 Apr 2024 15:39:14 GMT

We can't really reach a conclusion from the screenshot or the information provided. It would be best to raise a ticket with the support team so they can make sure that:

1. The Lakehouse exists and is accessible by the user creating the Dataflow Gen2

2. The Lakehouse is not corrupt and has a reachable endpoint

If this is only happening with a single Lakehouse, it could be an issue with the Lakehouse.

Re: MS Fabric connection to MS SQL on-premise data with dataflow gen2

Anonymous — Thu, 11 Apr 2024 07:49:55 GMT

Hi marius1106 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
Otherwise, please create a support ticket so team will look into your issue.
After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Re: MS Fabric connection to MS SQL on-premise data with dataflow gen2

Anonymous — Fri, 12 Apr 2024 08:39:38 GMT