Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
53 | |
23 | |
22 | |
20 | |
18 |
User | Count |
---|---|
46 | |
21 | |
20 | |
20 | |
18 |