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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
coolie
Helper I
Helper I

Bug in CopyData appending to partitioned table

 I can create a lakehouse partitioned table by selecting Overwrite in the destination options and choosing a column for the partition (simplified for this post):

coolie_0-1701268403883.png

Result:

coolie_0-1701270049188.png

 

The behaviour I expected for subsequent runs was one of the following:

  1. Keep as Overwrite - a partition with the same ID has data overwritten, but new partitions are created for new IDs, OR
  2. Change to Append - a partition with the same ID has data appended, but new partitions are created for new IDs.

Neither of these happens - 1) just overwrites everything and 2) gives an error - so how are you supposed to update a partitioned table? This is the error for Append:

 

"ErrorCode=TableActionNotSupportAppendToPartitionedTable,

'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,

Message=Table action 'Append' is not supported for writing into existing partitioned table."

1 REPLY 1
v-cboorla-msft
Microsoft Employee
Microsoft Employee

Hi @coolie 

 

This is a duplicate thread of the similar one available at the link : Duplicate Link 
Hence I am closing this thread. 

 

Thanks.

Helpful resources

Announcements
Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Free Fabric Certifications

Free Fabric Certifications

Get Fabric certified for free! Don't miss your chance.

January Fabric Update Carousel

Fabric Monthly Update - January 2026

Check out the January 2026 Fabric update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.