Forum Discussion
Incremental Refresh Synapse - Reduce Number of Concurrent Session
Community SupportHi, jlf81
According to my research, Azure VPN Gateways limit the number of Point-to-Site (P2S) connections allowed to a single gateway. SSTP Connections are limited to 128 concurrent connections for all VPN Gateway SKUs. There is not way to increase this limit, but most VPN clients will support one of the other protocols so connecting over a different protocol may help avoid the limit.
I think you can also refer to these documents to get the troubleshooting guidance and check if they can be helpful:
https://www.bluematador.com/docs/troubleshooting/azure-vpn-gateways
https://docs.microsoft.com/en-us/azure/vpn-gateway/vpn-gateway-troubleshoot
https://docs.microsoft.com/en-us/azure/vpn-gateway/tutorial-create-gateway-portal
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.
v-robertq-msft do you know how I can set them to queue the connections rather than rejecting them when they get to the limit.
As far as I can tell the problem is Power BI doesn't seem to intelligently manage the connections, it just keeps spamming then till it either completes it's refresh or hits an error
- v-robertq-msft
Hi, 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.