Creating a new table from different sources

[Anonymous]

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!

[petrovnikitamai]

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

[Anonymous]

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]

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

[Anonymous]

lt looks like it will not work with the workbooks that are password protected... right?