Forum Discussion
Incremental Refresh Synapse - Reduce Number of Concurrent Session
Community SupportHi, jlf81
As far as I’m concerned, you encountered the problem because you reached the limitation of the concurrent sessions, and you can not set the queue of the connections manually.
Here’s the limitation document, you can take a look:
A blog that explains the same problem as yours
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for those links, does this mean that there is no way to use incremental refresh on large complicated models? or is there another way to manage this not through the gateway?
My prefered solution on this would be to manage direct from Power BI and not use the gateway at all
- v-robertq-msft
Hi, jlf81
In my opinion, to deal with the errors that happened because it reached the limitation, the only way to solve this is to reduce the data volume and optimize performance. So reducing the data connections can be the possible method in this case.
If you want to get more possible ways to deal with the error you got, you can try to open a support ticket to get help from Microsoft:
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.