March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello community,
I'm trying to connect my fact table with my date table. The two fields that ensure this connection have exactly the same date format in the model view and in Power Query (image below). This connection works for part of the dates, all those from 01/01/2023 onwards, but not for the earlier dates, which is very strange.
How can I make this connection work for all the dates in my fact table?
I don't understand why it works for part of the dates and not all. Either it doesn't work at all, or it works completely.
Thank you very much for your help!
(This problem is driving me crazy haha)
Alex
Solved! Go to Solution.
Hi @Dangar332
Thanks for your reply!
After multiple checks, I realized that my fact table was connected to a dimension table A, which in turn was connected to a dimension table B. The relationship between these tables A & B was by mistake with a One to One (1:1) cardinality & a cross-filter direction set as both. Sorry for the inconvenience. I hope my case can still help another unfortunate person who makes this error with a large data model...
Have a good day!
Hi, @AlexFromValenci
Are there any entries in the Accounting_date column of your Fact Table prior to Year 2023?
Hi @Dangar332
Thanks for your reply!
After multiple checks, I realized that my fact table was connected to a dimension table A, which in turn was connected to a dimension table B. The relationship between these tables A & B was by mistake with a One to One (1:1) cardinality & a cross-filter direction set as both. Sorry for the inconvenience. I hope my case can still help another unfortunate person who makes this error with a large data model...
Have a good day!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
123 | |
85 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |