Forum Discussion
Best solution for Excel files as a source/Gateway/Refresh limit
Hi Applicable88 ,
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.
Please refer to the topic to see if it helps you.
Unable to schedule more than 8 refreshes with a "Premium per user" trial license
- Once assigned the App Workspace should have the PPU Icon as shown below.
- you can go into the dataset settings
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Applicable88 ,
What is your connection way?
It is caused by the connection mode. If the dataset is DirectQuery mode, we can configure refresh frequency. However, for Import mode, we just can configure the specific datatime, like below. You could add the time to refresh 8 times in one day.
For Power BI users, refreshing data typically means importing data from the original data sources into a dataset, either based on a refresh schedule or on-demand. You can perform multiple dataset refreshes daily, which might be necessary if the underlying source data changes frequently. Power BI limits datasets on shared capacity to eight daily dataset refreshes. The eight time values are stored in the backend database and are based on the local time zone that was selected on the Dataset Settings page. The scheduler checks which model should be refreshed and at what time(s). The quota of eight refreshes resets daily at 12:01 a.m. local time.
If the dataset resides on a Premium capacity, you can schedule up to 48 refreshes per day in the dataset settings.
More details: Data refresh in Power BI
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous thank you for your thorough answer. So besides DirectQuery Mode there is no method to get more than 48 refreshes per day? We have premium capacity which includes 48 already. But we need 4 refreshes in an hour.
Best.
Hi Applicable88 ,
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.
Please refer to the topic to see if it helps you.
Unable to schedule more than 8 refreshes with a "Premium per user" trial license
- Once assigned the App Workspace should have the PPU Icon as shown below.
- you can go into the dataset settings
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.