DataflowGen2 change source from SQL Sever to Fabric Lakehouse

DSanthoshKumar — Wed, 10 Jul 2024 14:35:25 GMT

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,

Re: DataflowGen2 change source from SQL Sever to Fabric Lakehouse

NandanHegde — Wed, 10 Jul 2024 14:50:48 GMT

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

topic Re: DataflowGen2 change source from SQL Sever to Fabric Lakehouse in Dataflow

DataflowGen2 change source from SQL Sever to Fabric Lakehouse

Re: DataflowGen2 change source from SQL Sever to Fabric Lakehouse