Forum Discussion

Pratima's avatar
Pratima
Icon for Advocate II rankAdvocate II
9 years ago

snowflake schema

Hi All,

How to deal with the Snowflake schema data model in Power BI.

 

These are the list of issuses i am facing while creating dashboard:

  • Getting values null
  • Not getting Aggregated values correctly
  • if we dont have relationship  with other table how to deal with this
  • if client will give snowflake schema

 

 

 

Thanks,

Pratima

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

7 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    9 years ago

    hi those are very broad problems which could have a multitude of issues creating the problems.

     

    1.  provide actual examples

    2. what are you your calculations?

    3. Screeshot of your relationships

    4. stating the problem and expected result?

    • Pratima's avatar
      Pratima
      Icon for Advocate II rankAdvocate II
      9 years ago

      Hi Dear,

       

      I have taken the  SQLServerAdventureDW2012. 

       

       

      In this DW I am facing above problems. 

       

      Thanks,

      Pratima 

      • vanessafvg's avatar
        vanessafvg
        Icon for Community Champion rankCommunity Champion
        9 years ago

        hi ok but can you highlight which measures are giving you those issues?    thats a big model, you still aren't saying where exactly the issues are or what you expecting.

         

        Please provide the actual detail of the issues with examples