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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Fabric Update Carousel

Fabric Monthly Update - October 2025

Check out the October 2025 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.