Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

andres_hirane

Disconnect from database after refresh (It is leaving connections open)

Submitted by on ‎06-21-2019 04:44 PM
We are experiencing lots of problems trying to refresh power Bi Datasets that query databases, either in Power Bi Desktop or using the On-premises data gateway. The problem is that after refreshing a table, the database connection doesn't close. Currently, we are full of open connection from Power BI in our databases. And in some of our databases we have a limit on the number of connections each user. As a result, reports fail to refresh. Is there any way to force the connections to close after the refresh? I think is a really nasty BUG
Status: Needs Votes
See more ideas labeled with:
2 Comments (2 New)
Comments
nishalit
New Member
‎10-30-2020 04:01 PM
We are experiencing lots of problems trying to refresh power Bi Datasets that query databases, either in Power Bi Desktop or using the On-premises data gateway. The problem is that after refreshing a table, the database connection doesn't close. Currently, we are full of open connection from Power BI in our databases. And in some of our databases we have a limit on the number of connections each user. As a result, reports fail to refresh. Is there any way to force the connections to close after the refresh? I think is a really nasty BUG
fbcideas_migusr
New Member
‎02-24-2025 05:54 PM
Status changed to: Needs Votes