Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Creating a new table from different sources

Hello,

 

I'm new to Power BI and not sure if this is the right place to ask, but let me try.

 

I have a couple of files with exactly the same tables (i.e. each table contains the same data - headers like vendor account, invoice amount, currency, invoice date, etc.). These are divided per regions (one file per one country). However, the data structure is the same.

 

What I'd like to do is to create one file with one table that will get information from all these files into one place. Please note that each "country file" can have many rows (i.e. Sweden can have 20 rows of data, but Germany can have 871 rows of data). I would like not to miss and not to overlap any row.

 

Is it possible to accomplish with Power BI? If yes, can you provide some instructions (direct or indirect - materials, youtube, tutorials, etc.)?

 

thanks a lot!

 

4 Replies

  • Put your all files in one folder and use the get data from folder (standart function) in power query

    • Anonymous's avatar
      Anonymous
      Not applicable

      thank you!

       

      1. what in a case that I have three folders (instead of one)?

      2. will it be automatically refreshed when someone loads new entry or do I have to refresh with any button?

      • petrovnikitamai's avatar
        petrovnikitamai
        Resolver V

        1.

        a)Put your folders in one parent folder and get data from parent folder

        b)Get data from folder 3 times and merge 3 tables in power query 


        Next step combine and edit


        For update data use Refresh desktop