Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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!!
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.