Option to disable parallel loading or limit data source connections.

[gabrielam1]

Currently the on-premises gateway opens more Oracle connections that we have license for.

[chtx]

I have same issue.

[chass]

Wanted to share that one reason we haven't done this is the fact it would make Oracle connections slower...something that users have been very vocal about not wanting.

[spencerl]

I believe you can do this by modifying the gateway config file per this posting: https://powerbi.microsoft.com/sv-se/blog/on-premises-data-gateway-january-update-is-now-available/ Summary: Here are the steps to change this configuration: On the gateway machine, open the file: [Program Files]\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config Find the “MashupDefaultPoolContainerMaxCount” setting. Change its value to the desired value. Save and restart the gateway. Changing this property value to 1 means that all queries will run sequentially, which could be desired for specific data sources that don’t support or don’t perform well with concurrent requests.

[Mark_English]

I am having the same issue with a TeraData database. System Admin said to see if there was a way to end sessions once query ended as sessions were remaining open for 20 minutes and causing connection limit to be reached.

[fbcideas_migusr]

this is such a ball ache. even in dev, without the gate way, it fails. cant we get the option of doing one table at a time. in query editor, I do it that way. But close and apply tries to connett all at once.

[wildmight]

We're experiencing issue with accessing Oracle corp DWH - getting error SESSION_PER_USER limit. DBAs are not always able to adjust number of sessions due to infosec policies.

[fbrowne]

This is causing major issues for our reporting team