CODEWITHSUNDEEP
powerbipowerquerym
bo-oz
bo-oz

Reputation: 2872

How to Append queries in Power BI / Power Query with Union instead of Union All

When I try to combine two datasets (coming from same table with exactly the same structure), I'm using

Table.Combine({table1, table2})

Unfortunately this results in the following native SQL:

SELECT *
FROM table1
UNION ALL
SELECT *
FROM table2

I'd prefer to use a normal UNION instead... is there a way to achieve this in M?

Upvotes: 2

Views: 837

Answers (1)

Mike Honey
Mike Honey

Reputation: 15017

The equivalent would be to add a Table.Distinct ( "Remove Duplicates" ) step, following the Table.Combine.

Upvotes: 1

Related Questions