Forum Discussion
Helper IIIKnow More about Datasets Refresh using Gateway in Power BI
Hi All,
I want to know more about Power BI Gateway. As we can use Gateway and schedule that 8 times per day. Is there any scope to more than 8-time per day schedule in Power BI?
Thanks,
Jay
Hi jaypatel ,
Firstly, the 8 scheduled times limitation is related to each dataset, not gateway, if you want to have more that 8 times, here are some ways:1. If the dataset resides on a Premium capacity, you can schedule up to 48 refreshes per day in the dataset settings. For more information, see Configure scheduled refresh later in this article. Datasets on a Premium capacity with the XMLA endpoint enabled for read-write support unlimited refresh operations when configured programmatically with TMSL or PowerShell.
2. execute an on-demand refresh manually, it has no counts limitation.
3. use Power Automate to execute an on-demand refresh, by scheduled or trigger, it also has 8 times limitation for each dataset, but based on my test, it does not shared with sheduled refresh, so the total is 8+8=16 times each day each dataset (The RESTful API share the limitation with scheduled refresh, within shared capacity)
Best regards,
3 Replies
v-lid-msftCommunity Support
Hi jaypatel ,
Firstly, the 8 scheduled times limitation is related to each dataset, not gateway, if you want to have more that 8 times, here are some ways:1. If the dataset resides on a Premium capacity, you can schedule up to 48 refreshes per day in the dataset settings. For more information, see Configure scheduled refresh later in this article. Datasets on a Premium capacity with the XMLA endpoint enabled for read-write support unlimited refresh operations when configured programmatically with TMSL or PowerShell.
2. execute an on-demand refresh manually, it has no counts limitation.
3. use Power Automate to execute an on-demand refresh, by scheduled or trigger, it also has 8 times limitation for each dataset, but based on my test, it does not shared with sheduled refresh, so the total is 8+8=16 times each day each dataset (The RESTful API share the limitation with scheduled refresh, within shared capacity)
Best regards,- amitchandak
Super User
jaypatel , Refer if this can help
https://radacad.com/the-power-bi-gateway-all-you-need-to-know
jaypatelHi Amit, Thank you so much for the reply. I have read that and did some research on it. But I didn't find anywhere that can satisfy my question.
