Last answered:

08 Jan 2021

Posted on:

24 Dec 2020

2

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)
Instructor
Posted on:

08 Jan 2021

1

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/

Submit an answer