cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
joaosantos Regular Visitor
Regular Visitor

Merge data models from various excel files

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

3 REPLIES 3
Super User
Super User

Re: Merge data models from various excel files

Hi @joaosantos ,

 

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




joaosantos Regular Visitor
Regular Visitor

Re: Merge data models from various excel files

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

Super User
Super User

Re: Merge data models from various excel files

Hi @joaosantos ,

 

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

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!