Forum Discussion
Report data temporarily changing mid-refresh
Hi all - I'm running into an odd issue with my reports in the Service.
I have a semantic model with a number of Kusto (KQL) queries in import mode. Occasionally, while a model refresh is in progress, the data from those queries in downstream reports in the Service will display incorrect values, then revert to their correct values once the refresh is completed.
As an example, the value was 305, during the refresh it displayed in the reports as 288, then immediately once the refresh completed, it displayed as 305 again. During the refresh, if I run the actual Kusto query in ADE, it still returns correct results, so I'm not sure what it's displaying in the interim. The upstream data itself isn't changing during that period.
I would imagine that reports in the Service wouldn't display updated data until the entire refresh is completed - is this correct? I've tried to reproduce the error in other ways since this seems like a weird bug, but haven't been successful. I've seen this happen multiple times now. Any clue why?
You can see this issue a lot with the Fabric Capacity Metrics app (its semantic model is coming from a Kusto db). Most likely culprit is the weird way Kusto is doing the batch ingestions, sometimes discarding and reloading batches (even older ones) - which leads to the results you observe.
2 Replies
You can see this issue a lot with the Fabric Capacity Metrics app (its semantic model is coming from a Kusto db). Most likely culprit is the weird way Kusto is doing the batch ingestions, sometimes discarding and reloading batches (even older ones) - which leads to the results you observe.
