Forum Discussion
Adding new tables from files in folder
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
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
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 🙂