Forum Discussion
Continued ContributorCan locking conflicts create an inability for a date table relationship to work properly? How to QA
Hi there. I am reasonably well experienced with PowerBI and am seeing something strange: a date table relationship failing despite one table having a solid Date element and the other table (the date table I have used for 5 years) being bulletproof. It's as if the date table relationship in powerbi is wrongly treating the date in the data table as text instead of date despite the table showing the datatype as date.
And PS there are locking conflicts in my model.
Would anyone have any high-level advice on how to interrogate why a relationship that looks correct fails? I recall that I had this a year or so ago and had to do something strange like add an INT() to the measure because of bug somewhere in PowerbI
1 Reply
- jdbuchanan71
Super User
Is it possible that the date field on your fact table is holding a datetime? So instead of 2022-07-01 it is 2022-07-01 11:17:53 for example. That would cause the relationship to the date table to fail since the date table would only have the date.
