Forum Discussion

gbarr12345's avatar
gbarr12345
Post Prodigy
2 years ago
Solved

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...
  • Ritaf1983's avatar
    2 years ago

    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