Forum Discussion

mail2vjj's avatar
mail2vjj
Helper III
9 years ago
Solved

Combine data from multiple excel file into one

I have run out of rows in my excel file.   I started a new excel file with the same table but with new data.   I need data from both these files in my data model.   How can I do that?   Thank...
  • Salvador's avatar
    Salvador
    9 years ago

    Hello Vishesh,

     

    I've created an example that you can download from my onedrive. 

     

     

    You will find images with the steps (1 to 4), a folder with both excel files, and the pbix file 😄

     

    If you experience any more dificulties, please tell.

     

    Regards,

    Salvador.