Forum Discussion

marius1106's avatar
marius1106
Icon for Helper II rankHelper II
2 years ago

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 d...
Dataflows
MOVC's avatar
MOVC
Icon for Resolver I rankResolver I
2 years ago

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. 

marius1106's avatar
marius1106
Icon for Helper II rankHelper II
2 years ago

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

  • MOVC's avatar
    MOVC
    Icon for Resolver I rankResolver I
    2 years ago

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