Forum Discussion

djskro's avatar
djskro
Frequent Visitor
1 year ago
Solved

Intermittent and Inconsistent Query Results in Direct Lake Model

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
1Expected
2Expected
...Expected
9Unexpected
10Expected

 

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