Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
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
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:
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
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
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |