Connection problem due to reaching maximum number of connections to Database (SQL)

[aah_enusa]

In our company we have a ODBC Oracle database with connections limited to 18 for all users. We work with a bunch of different Power BI files uploaded to the cloud which are configurated to be update automatically (usually once per day). All these Power BI works are connected to the same database. Our problem is that when updating one of these files, the maximum number of connections is immediately reached just within the same Power BI file. This is rare because the connection should be just one and number of tables a no more than 4, being in some cases only one. We don't quite understand the reason Power BI is creating different new connections to the database in parallel in just one file.

[aah_enusa]

Hi @nitishsh91

Thank you so much for the quick and on point response. That option was indeed marked in all files, so I deactivated it, saved the files and uploaded them to the cloud.

I still need confirm with database guy but that the number of connections does not increase (will do tomorrow) but I updated 5 files at once at no error showed up. So I think you solved my problem.

Thanks a lot!!

[nitishsh91]

Hi @aah_enusa 

Check in your PBI if below feature is enabled or dsiabled and accoridngly change it and then see if it helps:

Your dataset might be trying to refresh all tables in parallel reaching the connection threshold.