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

Hi v-robertq-msft 

 

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

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:

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/683031

 

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.