Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 model, however, when I create a simple report based on dates, I see a bunch of blanks! I have no idea where they are coming from.
Solved! Go to Solution.
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?
https://dax.tips/2019/11/28/clean-data-faster-reports/
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?
https://dax.tips/2019/11/28/clean-data-faster-reports/
Thank you! That was it, RI.
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |