Know More about Datasets Refresh using Gateway in Power BI

[jaypatel]

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

[v-lid-msft · Accepted solution]

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]

@jaypatel , Refer if this can help

https://radacad.com/the-power-bi-gateway-all-you-need-to-know

[jaypatel]

@amitchandak 

Hi 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.