Forum Discussion
Solved
Merge three differente excel databases with a different number of lines each
Hello everyone, I hope you're all doing well. My question is, I have three excel worksheets, the first one has the name and code of the client and the type of product he has purchased, the second ha...
LucasResendeR10 - You shouldn't need to merge them, just import them as separate tables and use Relationships to join them together.
Here's some guidance on relationships: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
If this helps, please mark it as the solution.
Hi LucasResendeR10 ,
I create three tables as you mentioned.
Then I go to the Power Query. I use Merge Queries.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.