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  
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?

      • PBIBharath's avatar
        PBIBharath
        Regular Visitor
        8 years ago

        Hi Maurice, 

         

        dont know how to share the file. This is how all the tables were created....

         

         

         

         

        there is no ID or unique identifier, just model , manufacturer and weight ...but in 15 different tables.. ..I would like to combine them in one single sheet ...