Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |