Forum Discussion
LucasResendeR10
2 years agoFrequent 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 ha...
- 2 years ago
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.
mark_endicott
2 years agoSuper 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.