Adding new tables from files in folder

[Anonymous]

Hi all

I am pulling data into Power BI via a folder. This folder currently has 22 files in it. Starting from Sept, I have 3 new tables I would like to add to Power BI. How do I do this? These tables won't be available in the previous 21 files only files starting from Sept onwards. I tried doing a normal combine and load, choosing the Sept file and choosing one of the required tables but it gave me errors when loading. 

Any assistance would be appreciated. 

Thank you. 

Regards

Karen

[Anonymous]

@TheoC Thank you. I thought that may have been what I had to do but I was hoping that I could keep all files in the same folder. Thank you very much for taking the time to provide me with this answer.  It is appreciated. 

K

[TheoC]

@Anonymous, you are more than welcome.  It is possible to keep them in the same folder, however, it does take a little bit of effort to get there and you will need to use the same folder multiple times to create a different queries for the 3 files as well (which would kind of defeat the purpose based on my understanding of your needs).

All the very best and don't hesitate to let the Community or I know if you need further help 🙂

[TheoC · Accepted solution]

Hi @Anonymous,

If the new tables have no alignment to the tables in the prior 22 files (e.g. 22 files are transactional data and the 3 new tables are HR Employee related), you will not be able to simply combine and load these.

I recommend that you separate the 3 new tables into their own folder (if they are of the same tabular format, structure) and combine and load these as one using Folder as Source, and continue to load the other files as you have been. 

Here are some links to some tips on using Folder as Source that may further assist:

• https://powerbi.tips/2016/06/loading-data-from-folder/
• https://insightsoftware.com/blog/power-bi-load-data-from-folder/
• https://www.c-sharpcorner.com/article/how-to-import-data-from-folder-into-power-bi/

Hope this helps. If it's not what you are after, please let me know so I or the Community can better assist.

All the best,

Theo