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
Community ChampionHi 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