Forum Discussion

roysampad91's avatar
roysampad91
Frequent Visitor
6 months ago
Solved

Report visuals showing incomplete data while semantic model refresh (incremental ref) is in progress

Hello All   I have a semantic model with Incremental Refresh set-up for last 15 days.  While my report is under scheduled refresh, if an user looks at the report he could only see partial data on ...
Need Help
  • v-achippa's avatar
    v-achippa
    5 months ago

    Hi roysampad91,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you Natarajan_M and cengizhanarslan for the prompt response.

     

    On shared capacity, the semantic model refresh and user queries use the same dataset instance. Since there is no query scale-out or read-only replica in shared capacity, some inconsistencies during refresh are expected platform behaviour, not a configuration issue.

    • The best possible way is to use Premium or Fabric capacity or schedule refresh during low usage hours.

     

    Thanks and regards,

    Anjan Kumar Chippa

roysampad91's avatar
roysampad91
Frequent Visitor
6 months ago

Thanks but i am on a shared capacity and users complain that for a split second or a couple of mins they could still see that the data is inconsistent. Is there any other workaround?

cengizhanarslan's avatar
cengizhanarslan
Super User
6 months ago

what Natarajan_M describes is actually a pretty simple workaround in your situation and as far as I know it is the best option in use. As soon as the refresh process completed, users could see refreshed data, while the model is in refresh process it would not affect the usage.

  • roysampad91's avatar
    roysampad91
    Frequent Visitor
    6 months ago

    I suspect this can be done for a non-premium capacity? If no, what's the alternative to address the concern of stale data during semantic model refresh is in progress?