Forum Discussion
Dim Table contains hidden blank value?
Hi, Anonymous
This screenshot alone can't tell that there is a problem with your real data. You need to check your fact table column.
Are they a one-to-many relationship? Is there other relationships between these two tables besides this column?
Community SupportHi, Anonymous
Check to see if there are values in the fact table that are not in the Dim Table, If the value can't be matched after the relationship is established, blank value will be generated.
Best Regards,
Community Support Team _ Janey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-janeyg-msft there looks to be no outliers in the dim or fact table.. The columns are both formatted as text.
- v-janeyg-msft
Hi, Anonymous
This screenshot alone can't tell that there is a problem with your real data. You need to check your fact table column.
Are they a one-to-many relationship? Is there other relationships between these two tables besides this column?
Hi v-janeyg-msft I did notice all of my dimenstion tables had a 1-to-many relationship with the fact table, except for one. This odd one out hada relationship going in the opposite direction, many in the dimenstion table and 1 in the fact table. Deleting this relationship removed the (blank)'s.
Thank you 🙂