Forum Discussion
Solved
Unexpected Blank dates on a data model
Hi, I have a fact table and a date dimension table in my power query model. There is no Blank on the date filed of the data source, and it doesn't even seem to exist in the imported data to the m...
Hi NimaM ,
This assumes that there is a referential integritiy violation with your data. You have more data from either your fact table, dimension, and/or date table. Here's a great blog post on RI violations. Can you check this and see if you see any RI violations?
Hi NimaM ,
This assumes that there is a referential integritiy violation with your data. You have more data from either your fact table, dimension, and/or date table. Here's a great blog post on RI violations. Can you check this and see if you see any RI violations?
Thank you! That was it, RI.