I have 10 separate databases- one for each Company. Each Company has branches and departments.
Each Company(DB) has a BranchTable, a Department table and a Transaction Table. In the attached pbix file I have a simple example for Branches derived from tables in Excel.
I have established a relationship between the two tables for Branch Code - however, it is a many to many relationship. While a newbie to PowerBI, I remember Sam saying that many-to-many relationships are / should be the exception. I will also have the same issue when I bring in departments within a branch (within a company)
In this example do I have to settle for the many-to-many or is there a way I can establish one-many relationships?
if I do have to settle for the many-to-many what do I need to watch out for?
ManytoMany.pbix (46.1 KB)