Merge three differente excel databases with a different number of lines each

[LucasResendeR10]

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 has the code of the client and personal informations, and the third has the code of the client and the manager it was assigned to. The problem is, the manager file has fewer lines, because more than one client can be assigned to the same manager, there are several repeted client codes because the same client can aquire differente products, and when I merge these databases in power query, I want to see the entire table to show all the clients with its respective manager, and code, even if it is a duplicate. But when I try to merge them, it is limited by the umber of line from the manager files, whitch has fewer lines. Can someone help me solve this?

[v-yilong-msft]

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.

[mark_endicott · Accepted solution]

@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.