Option to disable parallel loading or limit data source connections.
Currently the on-premises gateway opens more Oracle connections that we have license for.
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.
Felix Browne commented
This is causing major issues for our reporting team
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.
Lyle Spencer commented
I believe you can do this by modifying the gateway config file per this posting:
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.
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.
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.
Carlos Teixeira commented
I have same issue.