Gabriela Mackay on 08 Dec 2017 03:45:23
Currently the on-premises gateway opens more Oracle connections that we have license for.
- Comments (7)
RE: Option to disable parallel loading or limit data source connections.
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.
RE: Option to disable parallel loading or limit data source connections.
This is causing major issues for our reporting team
RE: Option to disable parallel loading or limit data source connections.
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.
RE: Option to disable parallel loading or limit data source connections.
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.
RE: Option to disable parallel loading or limit data source connections.
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.
RE: Option to disable parallel loading or limit data source connections.
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.
RE: Option to disable parallel loading or limit data source connections.
I have same issue.