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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
SamiaSouissi
Regular Visitor

Issue with append queries

Hello,

I attempted to append two queries that share the same columns, intending to add rows of data from the second table to the first. However, I encountered an issue with the date column. Power Query created a new column named 'date' and added the new data to it separately, instead of appending it to the existing column. I have verified the names and formats of the two columns, and have tried multiple times, but the result remains the same: two separate columns instead of a single one with appended data.

Have you any ideas please ?

SamiaSouissi_0-1711878346360.png

SamiaSouissi_3-1711878452750.png

 

 

 

1 ACCEPTED SOLUTION
slorin
Super User
Super User

Bonjour @SamiaSouissi 

N'y a t'il pas un espace après le mot "Date" ?

Stéphane 

View solution in original post

3 REPLIES 3
peruloganathan
New Member

Ihave created a power bi report , in which i have appended sales data of individual months from Jan 24 to Aug 24 using append queries option in tab. But while running a report iam getting double entry of billed Quantity in only Aug 24 selection of date. Kindly give solution to this problem

SamiaSouissi
Regular Visitor

Oui, c'était ça le problème, merci beacoup !

slorin
Super User
Super User

Bonjour @SamiaSouissi 

N'y a t'il pas un espace après le mot "Date" ?

Stéphane 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.