Forum Discussion

PBIBharath's avatar
PBIBharath
Regular Visitor
8 years ago

how to merge multiple tables

I have 15 tables, with the same column names , but different row values in each table.

how to combine these tables, so I can see all the row values in one single table.  

thank you

 

17 Replies

  • MauriceMecowe's avatar
    MauriceMecowe
    Icon for Resolver II rankResolver II
    8 years ago

    Use the append ability within Power BI to merge the tables. You can find it when you go to the "Edit Queries" screen under the Home tab.

     

     

    • PBIBharath's avatar
      PBIBharath
      Regular Visitor
      8 years ago

      Hi Ruslan, I tried that but I'm getting some error. The columns values were duplicated and the row values are all over ..as below 

       

      • MauriceMecowe's avatar
        MauriceMecowe
        Icon for Resolver II rankResolver II
        8 years ago

        Are the column types the same for both tables? Could you otherwise share the pbi file?