Merge data models from various excel files

[Anonymous]

Hello, Is itt possible to merge automatically the data in the data models of various excel files with the same data model and file structure?

Ty,João

[MFelix]

Hi @Anonymous ,

Power BI as an option to get data from folders, in this case a function is created and all files on that folder are treated in the same way, so you only have to setup the steps of the query once and the information will be merged.

Check the documentation on PBI.

Regards,

MFelix

[Anonymous]

But I can't access each data model directly via importing folder/files, right?

[MFelix]

Hi @Anonymous ,

If the files have the same models / format it will be done automatically.

Regards,

MFelix