Hi. How can i import dim-date file and fact-internals file at the same time to PBI?

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/

Follow this topic

Afsana Gadirova

Last answered:

08 Jan 2021

Posted on:

24 Dec 2020

Import more than one file

in Power BI / Active vs Inactive Relationships

1 answers ( 0 marked as helpful)

365 Team

Instructor

Posted on:

08 Jan 2021

Import more than one file

Submit an answer

related questions