Forum Discussion
Dataflow issue
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)
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
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.
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)
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?
For each fact table start by describing the "grain", eg what does a single row represent and what describes it.
For a sales table the grain might be a product, sold to a customer on a specific date. Eg ProductID, CustomerId and Date describe the row. You then have Product, Customer and Date dimensions.
With multiple fact tables you want to share those dimensions (these are called conformed dimensions).
If you can describe the rows of your fact tables we can then help suggest the dimension tables you need.
