Forum Discussion
Problems with refreshing of semantic model - continuation
Hi Anonymous
That is a good overview of the Microsoft documentation on the issue, kudos for that.
I read through several articles and I don't think there is a clear-cut solution for the problem. Seems to me that the automatic refresh of the semantic model causes problems, since there is no clear-cut framing for a bigger ETL processes (several tables being overwritten at different stages). It is even mentioned in the documentation (see screenshot):
After I disabled the automatic update and only use manual/pipeline refresh, it seems to work better.
Thank you for your kudos.
For the result you observed, my understanding is that manual or pipeline refreshes might change the priority of tasks.
Typically, manual refreshes (on-demand refreshes) have a higher priority to allow users to see the changes or results of their actions more quickly. On the other hand, automatic refreshes usually occur as background operations, and their execution priority is automatically arranged by the backend based on available resources and other factors.
However, as users, it is difficult for us to know the specific execution mechanism of the backend.
Best Regards,
Jing