Forum Discussion
Helper VData Modeling Requirements - Cardinality and Primary/Secondary Keys
Please assist i am trying to create a star scheme in SSAS and pull it into PowerBI. I believe "PI_ServiceRequest" is my fact table and the rest dimensions.
See my data model in Powerbi. I would like to know if my model is correct in terms of relationship cardinality and also am i correct to define the "id" column in all tables as primary?
https://drive.google.com/file/d/1yWfBp75UdoczDWTyq9Gj4SMpQZ1u8gIK/view?usp=sharing
Hi Yrstruly2021 ,
Do not use Both Cross filter direction when designing snowflake models.
In general, fact tables have multiple dimensions,but according to your description, there is only one dimension of ID in the fact table.
You can learn more about from this document:
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema#star-schema-overview
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
V-lianl-msftCommunity Support
Hi Yrstruly2021 ,
Do not use Both Cross filter direction when designing snowflake models.
In general, fact tables have multiple dimensions,but according to your description, there is only one dimension of ID in the fact table.
You can learn more about from this document:
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema#star-schema-overview
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.