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

Natarajan_M's avatar
Natarajan_M
Super User
6 months ago

Hi roysampad91 , 

PBI by default will isolate the refresh process in the sense it takes a copy of the dataset and performs refresh while the main copy will be serving the users post refresh the updated copy will replace the old . 

During this perod you should be seeing the data as per the previous day refresh . check your refresh configuration . it will smoothly transaction the data partitions without out notice .

check query scaleout feature : 
https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/service-premium-scale-out