topic snowflake schema in Desktop

snowflake schema

Pratima — Tue, 23 May 2017 11:33:48 GMT

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

Re: snowflake schema

vanessafvg — Tue, 23 May 2017 11:47:54 GMT

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?

Re: snowflake schema

Pratima — Tue, 23 May 2017 12:35:19 GMT

Hi Dear,

I have taken the SQLServerAdventureDW2012.

In this DW I am facing above problems.

Thanks,

Pratima

Re: snowflake schema

vanessafvg — Tue, 23 May 2017 14:15:57 GMT

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

Re: snowflake schema

Pratima — Tue, 23 May 2017 15:32:22 GMT

Hi i am trying get values from indirect relationship tables like

(geography wise unitcost as well as customer wise unit cose)

here i am getting like this and cannt found autodetect relationship

Help me on these

Re: snowflake schema

v-yulgu-msft — Thu, 25 May 2017 02:12:56 GMT

Hi Pratima,

What visual did you use? What columns and measures did you add to this visual that caused this error? Please click on 'See Details' to get more detailed error message.

Regards,
Yuliana Gu

Re: snowflake schema

Pratima — Mon, 29 May 2017 09:16:27 GMT

Hi Yuliana Gu,

As I mentioned earlier Email like:

For these fields for any visualisation types..................

e.g. (geography wise unit cost as well as customer wise unit cost)

here I am getting like this and can't found autodetect relationship

Thanks,

Pratima

Re: snowflake schema

beginnerPBIuser — Mon, 29 Aug 2022 16:21:10 GMT

Hi .

Your post i a couple of years old but i am facing the same problem, how did you solve your problem.

Please do respond.

All and any help is greatly appriciated. Thanks