Forum Discussion
Helper IIIAnyway to stagger scheduled updates/refresh within a single powerBI?
Hi all
Hitting an issue where my server has a limit on the number of connections it can have and I've run into an issue whereby I am unable to refresh/update my powerBI due to this, it throws an error.
Is there anyway I can make PowerBI update tables/data sources individually so it gets around this issue?
Any help much appreciated
Ayupchap,
You can periodically restart gateway using script as described in the similar thread below, which will force gateway to flush out connections.
https://community.powerbi.com/t5/Integrations-with-Files-and/On-Premises-Gateway-utilizing-many-Oracle-database-connections/m-p/153324#M9284
Regards,
Lydia
2 Replies
Ayupchap,
You can periodically restart gateway using script as described in the similar thread below, which will force gateway to flush out connections.
https://community.powerbi.com/t5/Integrations-with-Files-and/On-Premises-Gateway-utilizing-many-Oracle-database-connections/m-p/153324#M9284
Regards,
Lydia
AyupchapThis is amazing thanks so much!