Anyway to stagger scheduled updates/refresh within a single powerBI?

[Ayupchap]

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

[v-yuezhe-msft · Accepted solution]

@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-Orac...

Regards,
Lydia

[Ayupchap]

This is amazing thanks so much!