DataflowGen2 change source from SQL Sever to Fabric Lakehouse

[DSanthoshKumar]

Hi,

On DataflowGen2 we have taken source as SQL Server OnPrem and loaded data to Fabric Lakehouse.

Now we want to change the source connection as other Fabric Lakehouse.

Is it possible?

If no, can you suggest the work around for it.

Thanks,

[NandanHegde · Accepted solution]

Can you be a little clear with your ask ?
Do you mean to say that the data source which was originally onprem SQL server has now shifted to a lakehouse and you want to update your dataflow gen2 source connection from on prem to lakehouse?

(with all other aspects the same)

If this is your ask, it is doable wherein you can update the Power query in the advanced editor of your Dataflow