Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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?
Solved! Go to 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.
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.
@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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
77 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
70 | |
63 | |
55 | |
48 | |
46 |