Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
amoghshahane
Frequent Visitor

Cannot see destination table structure in Copy Data activity : Mapping sink is empty

Hello,

 

I am creating a Pipeline and using a Copy Data activity in it. The source and sink for the Copy Data are two Lakehouses in separate workspaces. I have selected the source and the destination tables but cannot see the destination table structure while mapping the fields manually:

amoghshahane_0-1738224173763.png

 

Based on below Community discussion, I even renamed the columns in destination table to match with source but the issue persists. Further, Import Schema option does not either does not return any result or creates a new table in the destination.

Solved: Error - Mapping Sink is Empty. - Microsoft Fabric Community

 

Can someone please help me in solving this?

 

Thanks a lot!

Amogh

3 REPLIES 3
amoghshahane
Frequent Visitor

Update:

I did not find a solution to this but a workaround: I followed below article and through 'Add dynamic content' option, I could replicate full table from source to destination - my original requirement was to just replicate few columns and not entire table:

Copy Data from Lakehouse in Another Workspace Using Data pipeline | Microsoft Fabric Blog | Microsof...

 

Also, the option insert as overwrite had to be selected for this to work.

Please let me know if someone finds a better solution.

 

Cheers,

Amogh

amoghshahane
Frequent Visitor

Hello @Anonymous ,

 

Thank you for the suggestion!

I have tried using the same table name and column names but it still does not work. Just to mention, I have multiple columns in my source while I'm using only 2 of those in my destination. Can the number of fields be the problem?

 

Appreciate your support!

 

Thanks,

Amogh

Anonymous
Not applicable

Hi @amoghshahane ,

 

Please check the table and column names to make sure that the table and column names in the destination table match exactly those in the source table. Even small differences can cause mapping problems.

 

Also, you can refer to below document:

How to copy data using copy activity - Microsoft Fabric | Microsoft Learn

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.