Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

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

      • MFelix's avatar
        MFelix
        Super User
        7 years ago

        Hi Anonymous ,

         

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

         

        Regards,

        MFelix