Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Joining Multiple tables together

Hi all,

 

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), 

does anyone know a efficient way of joining them together on power bi? 

 

P.s. I've tried merge but it only allows for two tables rather than 6tables

 

Thank You!

data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • Seanan's avatar
    Seanan
    Icon for Solution Supplier rankSolution Supplier
    4 years ago

    Hi Anonymous 

    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.

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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

       

      • Seanan's avatar
        Seanan
        Icon for Solution Supplier rankSolution Supplier
        4 years ago

        Hi Anonymous 

        Would you be able to provide some example tables?