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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August 2025 community update carousel

Fabric Community Update - August 2025

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