Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Join multiple different tables

Hello,

I have loaded 6 tables in power bi. Combination of date and email would act as unique identifier for each table. I want to merge all 6 tables based on date and email to create sort of one super table, then use that super table for my visualisation.

I need to update these tables on weekly basis, so could you suggest me what to do here. Is there a way to do it in a clean way.

 

Thanks

Jitendra

Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous you can use append features in power query to make super table. There are many blog on how to combine multiple files from a folder. Hope this video help.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      parry2k  Thanks for the reply. I think I didn't put my question properly. I am looking for something like merge query (want to join 6 tables in one go).

      Isn't append is for putting row data one below other? I want to column merge them. I have read somewhere that you can do that in one go in sql, don't know how to do that in power bi. I tried joining them one by one using full outer join but that seems lees intuitive.

      Updating later on is no problem at the moment as I will manually update them in excel and refresh it in power bi. I hope that won't be problem.

      I am new to power bi.

      Thanks

      Jitendra