cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Eric7
Frequent Visitor

On-premises gateway, setting DbConnectionPoolMaxSize against Oracle

Hi, the on-premises gateway does take quite a lot of simultaneous database connections against our Oracle database when we refresh a dataflow residing in the Power BI Service or in the PowerApps/Power platform. It looks like it consumes about the same amount as the number of tables in the dataflow. Is there any way to limit this? I have tried to set DbConnectionPoolMaxSize=4 (the default was 256 i believe) in the following file on the gateway server

 

C:\Program Files\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config

 

in sections

 

<setting name="DbConnectionPoolMinSize" serializeAs="String">

<value>4</value>

</setting>

 

<setting name="DbConnectionPoolMaxSize" serializeAs="String">

<value>4</value>

</setting>

 

<setting name="DbConnectionStatefulPoolMaxSize" serializeAs="String">

<value>4</value>

</setting>

 

But the gateway still consumes 9 connections simultaneously.

If we start several refreshes against Oracle at the same time, we may easily end up starving our main business critical application for database connections.

 

Anyone who has more knowledge about this?

 

-Is it possible to set the DbConnectionPoolMaxSize?

-Is there a minimum value not possible to go under?

-Is this the right place or the right setting?

 

 

Eirik

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@Eric7 

For Power Apps questions you may go to Power Apps Community - Power Platform Community (microsoft.com).

 

Best Regards

Paul Zheng _ Community Support Team

Hi, this issue also pertains to dataflows in the Power BI Service, I have updated the original question.

 

Eric7

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors