Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Problem with Data Model

  • 1.  Problem with Data Model

    Posted 12 days ago
    Edited by Norbert Empting 12 days ago
    Hi everyone,

    I habe been using Power BI for a while now, building simple Data Models and Reports.

    Now I have encountered a Problem, I can't find a solution for.

    I want to connect a many to many Relationship and i can't quite figure it out. It is about regional Data, so can you recommend any helpful tutorials?

    Thanks in advance!

    ------------------------------
    Norbert
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Problem with Data Model

    Top Contributor
    Posted 12 days ago
    Are these tables "dimension" tables, "fact" tables, or both?
    Are you planning to filter one table by the other, or the other way round, or both?

    Basically, your business goal (what you are trying to achieve) will impact your data model decisions.

    ------------------------------
    Lutz
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Problem with Data Model

    Posted 10 days ago
    You should never connect a "fact table" to another "fact table"... especially if you do not have much experience in data modeling.   Without knowing all the details, I would suggest that you use a Bridge Table between the 2.  The bridge table would be a unique table that will serve as a "one side" to the "many side" of your tables.

    There are many videos on youtube explaining bridge tables. Good luck.

    ------------------------------
    Ka Ly
    Clinical Informatics Program Manager
    ------------------------------

    Academy - Online Interactive Learning from Experts