Forum Discussion
Incremental Refresh Synapse - Reduce Number of Concurrent Session
Solution SpecialistThough your source is cloud and doesn't require gateway for refresh, we can still set up gateway to control the number of concurrent sessions. That's the reason I suggested you to use gateway and I am not sure if we can control this if we do not use gateway.
To start with, install a gateway and add your Synapse datasource under that gateway.
Once set up, follow the article I provided and change the gateway configuration file.
Once done, do a refresh and observe the behaviour.
Morning, I spent all of yesterday looking into Gateways and the issue I have is that I don't have a machine to stand the on prem gateway on, so I was looking into VNet gateways.
Do you know if there is anyway to do the what you surguest with them.
I now have one setup and get the concurent connections errors, but I don't know where to start in limiting these in the Vnet Gateway. Any pointers?
- v-robertq-msft
Community Support
Hi, 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.
