Forum Discussion
Coping up with SQL end point lag
Can you please elaborate with example
"the first query you run on the endpoint will freeze the data for all other queries until it completes. If the initial query runs for a long time, you will get stale data for all subsequent queries"
Are you suggesting that, if different semantic models send out different queries to sql end point at the same time , they could be completely inaccurate due to the condition mentioned above?
Hi smpa01 ,
If you want to know more, please refer to the 11th reply of this similar case:
Solved: SQL Endpoint Slow To Reflect Changes In Lakehouse - Page 2 - Microsoft Fabric Community
This also provides some workarounds.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!