Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
DSanthoshKumar
Regular Visitor

DataflowGen2 change source from SQL Sever to Fabric Lakehouse

‎07-10-2024 07:35 AM

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,

Labels:
Message 1 of 2
270 Views
0
1 ACCEPTED SOLUTION
NandanHegde
Super User
Super User

‎07-10-2024 07:50 AM

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

NandanHegde_0-1720623016290.png

 




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

Message 2 of 2
265 Views
0
1 REPLY 1
NandanHegde
Super User
Super User

‎07-10-2024 07:50 AM

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

NandanHegde_0-1720623016290.png

 




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
Message 2 of 2
266 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All
Top Solution Authors
View All