Import more than one file
Hi. How can i import dim-date file and fact-internals file at the same time to PBI?
1 answers ( 0 marked as helpful)
365 Team
Instructor
Hey Afsana,
Thank you for the question.
The dim-date file and the fact-internals file have different data structure, so you have to import them separately.
If you have two or more files with the same data structure, you can put them in a folder and import the entire folder in Power BI. You can find more information about this process at the links below. However, even then the process is complex and we advise that you avoid it if you can.
https://powerbi.tips/2016/08/load-multiple-excel-xlsx-files/
https://sqlitybi.com/loading-multiple-excel-files-from-a-folder-in-power-bi/