Excessive connections/sessions in Oracle database from desktop - direct query

[davebi]

We are developing some reports that we eventually want to publish to premium capacity gateway server daskboards.  We are receiving messages from an oracle database session log that we have developed to show users with more than 50 concurrent connections.  We have found that we have often over 100 open sessions during development in desktop.  These stay active on the Oracle database server until we manually kill them.  All reports are direct query to Oracle using odac.  Most sessions are running Microsoft.Mashup.Container.Net FX45.exe or msmdsrv.exe

Is there a way to ensure that these connections are terminated once the query is done?  Tables involved in the queries are very small - aggregated by the ERP to under 250 records.  Any recommendations for troubleshooting the issue?

[v-lionel-msft]

Hi @davebi ,

"Is there a way to ensure that these connections are terminated once the query is done? "

When you use the Direct Query connection mode, Power BI's connection to the data source is always maintained, which means that your  idea is not feasible in the current version. 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.