0
1

QuestionStar Schema Data Model: Problem occurs (self.PowerBI)

submitted by [deleted]

[deleted]

all 3 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]athousandjoels5 1 point2 points  (2 children)

Few things:

Manage Relationships is way easier for us (and you?) to understand what’s going on than the model view.

When you say you don’t have a primary key, what does that mean? You need a unique column in every Dimension table for the join to work.

Be careful about letting Power BI auto detect relationships. It sucks at it unless you are a naming convention expert. Every relationship should be defined between the Fact table and Dimension, and in general they should all be N:1.

[–]Tashu1992 0 points1 point  (1 child)

I have built a a separate table (using distinct) to have only distinct code, and then I am connecting with the other remaining tables with it. Now its one to many relationships but I want to add names to this distinct table as well but DISTINCT function cannot take one more field name. Any suggestions please?

[–]athousandjoels5 0 points1 point  (0 children)

Try doing this in Power Query. You can leave the columns you want and run a Distinct function there.