Forum Discussion

jlf81's avatar
jlf81
Frequent Visitor
5 years ago

Incremental Refresh Synapse - Reduce Number of Concurrent Session

Does anyone know how I can reduce the number of connections in a intial load of a incremental refresh Power BI Dataset that connects to Synapse.   I have a number of tables in a start schema that I...
Need Help
jlf81's avatar
jlf81
Frequent Visitor
5 years ago

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's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
5 years ago

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:

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits

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.