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

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

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
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.

June 2025 community update carousel

Fabric Community Update - June 2025

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