Forum Discussion

MJAGUSIAK's avatar
MJAGUSIAK
Helper I
4 years ago
Solved

Dataflow issue

All- im having issues with my data flow talking across all of my tables. Im trying to use the date table to sort by month and use the client table to sort by brand. but the brand is only sorting fo...
Need Help
  • ALLUREAN's avatar
    ALLUREAN
    4 years ago

    It is good if you follow e.g. star schema in your model. For example all dimension tables like Date should be in single relationship to your fact table/s (one-to-many)

ALLUREAN's avatar
ALLUREAN
Solution Sage
4 years ago

Hi, MJAGUSIAK 

You need to fix your data model first, that might cause a lot of issues. It is not recommended using bi-directional relationship in all tables

  • MJAGUSIAK's avatar
    MJAGUSIAK
    Helper I
    4 years ago

    Can you explain what you mean by fix my data model? What could be causing the issue? 
    Ive spent 8 weeks now trying to self teach Power BI. Not sure if my starting point is screwed up. 

    • ALLUREAN's avatar
      ALLUREAN
      Solution Sage
      4 years ago

      It is good if you follow e.g. star schema in your model. For example all dimension tables like Date should be in single relationship to your fact table/s (one-to-many)

      • MJAGUSIAK's avatar
        MJAGUSIAK
        Helper I
        4 years ago

        Ok i just remodeled it to look like this, using the CYBS TR table and PDE 17 table both as fact tables. is this allowed in a star schema? and it wont let me select anything other than M*M. any ideas on that?