Hello,
I have a Direct Lake model. "Keep your Direct Lake data up to date" is enabled. Something strange is happening.
When I connect to the model and run a given DAX query on it, I receive an expected result about 9/10 times, but, every 10th time or so I will get a result that is erroneous and does not match the expected result. If I run the query again immediately after getting the erroneous result, I get the expected result again. The query doesn't change. Here's what it will look like:
| Query Attempt # | Result |
| 1 | Expected |
| 2 | Expected |
| ... | Expected |
| 9 | Unexpected |
| 10 | Expected |
This will all occur in a time-span of 2-3 minutes or so.
I am not able to explain this behavior. I have a suspicion that it has something to do with How Direct Lake is purging content when it recompresses data, but I'm not sure how to investigate this.
My initial thinking is that doing DAX debugging wouldn't be helpful, as the DAX isn't changing and works as expected most of the time. How should I go about investigating/debugging this?
Many thanks
