Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Merging before transformation

Hi everyone,

 

Is it possible to merge 2 Excel files in Power BI before any transformation ? 

In fact, i have so much lines that Excel crashes when I try to paste the lines into one only file.

So, I'm trying to do it in Power BI and the transformations are the same for both files. If yes, how can I do it? 

 

Someone could help me?

 

Thanks in advance for your help.

  • are they the same structure?  or different?  you can use merge or append in power query 

2 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion

    are they the same structure?  or different?  you can use merge or append in power query 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Exactly the same structure. I append a query before the other transformations steps and it works 😉 thanks