Forum Discussion
Know More about Datasets Refresh using Gateway in Power BI
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,
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,