Forum Discussion
Relationship issue
Hi there,
I have data in excel that I've imported into Power BI.
The only issue is that both of the data is transactional data and I need them to connect.
The only relationship I can only do is a Many to Many which I know isn't reliable.
Can anybody help me in fixing the relationships please if possible?
I have attached the sample PBIX and sample data I created which mirrors the data I was provided (with different headings and numbers of course). Please see below:
PBIX - https://drive.google.com/file/d/10yZDO4Q7RqrIw02WPlZ0fglhcrtiMpCi/view?usp=drive_link
Hi gbarr12345
o answer your question, it's necessary to understand the logic behind what you're trying to do, as it’s not clear at this moment.
On a technical level, the tables appear to have the same structure, so it’s unclear why you’re not performing a union (combining them vertically with a classified column if they represent different actions). The many-to-many relationships that have been created are due to the lack of a unique key for each table. Technically, you could address this by creating a bridge table, but that’s only part of the solution, as it’s not clear what you’re trying to achieve logically.
More information about many-to-many and bridges tables is here :
https://www.youtube.com/watch?v=aPLaun-tTgQ
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
Hi gbarr12345
o answer your question, it's necessary to understand the logic behind what you're trying to do, as it’s not clear at this moment.
On a technical level, the tables appear to have the same structure, so it’s unclear why you’re not performing a union (combining them vertically with a classified column if they represent different actions). The many-to-many relationships that have been created are due to the lack of a unique key for each table. Technically, you could address this by creating a bridge table, but that’s only part of the solution, as it’s not clear what you’re trying to achieve logically.
More information about many-to-many and bridges tables is here :
https://www.youtube.com/watch?v=aPLaun-tTgQ
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thanks very much for your help Rita! Much appreciated!
Happy to help☺️
