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?
Hi v-janeyg-msft there looks to be no outliers in the dim or fact table.. The columns are both formatted as text.
Community SupportHi, 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 🙂