Append two or more merged data tables

[mibu]

Hey Team!

Is it okay to append two or more merged data tables provided their columns are identical?  Thanks!

Best,

mibu

[v-rzhou-msft · Accepted solution]

Hi @mibu ,

As far as I know, Power BI support us to append multiple tables in Power Query at one time. However for merge, we could only merge two tables at one time. If you want to merge multiple tables, you need to merge N-1 times.

Append:

Merge:

For reference:

Append queries

Merge queries overview

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.