Forum Discussion

Yrstruly2021's avatar
Yrstruly2021
Icon for Helper V rankHelper V
4 years ago
Solved

Data 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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    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.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
4 years ago

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.