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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
subhotech
Regular Visitor

Missing Records after doing union of two datasets

Hi , I have two data set in powerBI query editor which are connected to MS Sql Server. I am trying to union those data sets to create a new dataset having all the records using 'Append as New' functionality. I can see missing records in the final dataset. Source A has 10 records ( example) Source B has 20 records ( example) Final Dataset has < 30 records. Both dataset has same number/order of columns which is necessary for doing union i.e Append in PowerBI. Please Advice! Regards,

1 REPLY 1
MarcelBeug
Community Champion
Community Champion

When appending 2 queries in the Query Editor, the tables can have completely different definitions.

 

The generated code looks like:

 

= Table.Combine({Query1, Query2})

 

No records will be lost.

 

In the example below, Query1 has 1 column with numbers and Query2 has 1 column with text:

 

Append tables.png

 

So maybe you are doing something else?

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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