Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
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:
So maybe you are doing something else?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |