Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
LucasResendeR10
Frequent Visitor

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 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?

1 ACCEPTED SOLUTION
mark_endicott
Super User
Super User

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @LucasResendeR10 ,

I create three tables as you mentioned.

vyilongmsft_0-1717393884496.png

Then I go to the Power Query. I use Merge Queries.

vyilongmsft_2-1717395267672.png

vyilongmsft_1-1717395200352.png

vyilongmsft_3-1717395450376.png

 

 

 

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
Super User
Super User

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.