Joining Multiple tables together

Question

Hi all,&nbsp;I have an issue that i been struggling to fix, I have a 6 tables(tbl1, tbl1...) from different sources that all have a shared column(regionID),&nbsp;does anyone know a efficient way of joining them together on power bi?&nbsp;&nbsp;P.s. I've tried merge but it only allows for two tables rather than 6tables&nbsp;Thank You!

seanan · Answer

Hi&nbsp;Anonymous&nbsp;
You could append all of the tables together into 1 new table. The append feature allows for more than just 2 tables. However, you may have to remove null values from some columns.

&nbsp;
&nbsp;
&nbsp;

anonymous · Answer

would append work on tables that do not have the same column structure?&nbsp;

seanan · Answer

Hi&nbsp;Anonymous&nbsp;
Would you be able to provide some example tables?

Forum Discussion

Joining Multiple tables together

3 Replies

Related content

Join 3 fact table together with one-to-many relationship

Joining multiple tables/queries

Join tables based on multiple columns

conditional join

Join the community