- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
MS Fabric connection to MS SQL on-premise data with dataflow gen2
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The dataflow and the lakehouse is both in "my workspace"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apologies, I must have misread the screenshot. I would just try doing this in a regular premium or trial capacity workspace instead.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-20-2024 07:20 AM | |||
07-16-2024 01:51 AM | |||
02-14-2025 01:25 AM | |||
12-12-2024 02:06 PM | |||
08-21-2024 09:43 AM |
User | Count |
---|---|
3 | |
3 | |
1 | |
1 |