How to set data set refresh time at 7:15,8:20,10:25,7:45,11:55,etc in PowerBI service??

[Saideep_Vemula]

How to set data set refresh time at 7:15,8:20,10:25,7:45,11:55,etc in PowerBI service as we have only two options available as of now with rounded timings like 7:00am or 7:30??

[v-binbinyu-msft · Accepted solution]

Hi @Saideep_Vemula ,

In power bi service portal, you can only set the refresh time with 30 minute intervals.
For your demands, you can choose a RPA tool to refresh the data, such as Power Automate.

For more details, you can read related document:How to Schedule Unlimited Power BI Dataset Refreshes with a Simple Power Automate | by Maurice Henry...

Or you can also write a script to call the Power BI Rest API

For more details, you can read related document: Datasets - Refresh Dataset - REST API (Power BI Power BI REST APIs) | Microsoft Docs, Datasets - Refresh Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[otravers]

The easiest no-code way is to trigger Power BI refreshes from a scheduled flow in Power Automate, you could also write a script that calls the Power BI REST API.

[ribisht17]

@Saideep_Vemula 

Depends upon the type of license you should get the option.

With Power BI Pro we can arefresh up-to 8 times a day

Data refresh

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

It is also important to call out that the shared-capacity limitation for daily refreshes applies to both scheduled refreshes and API refreshes combined. You can also trigger an on-demand refresh by selecting Refresh now in the dataset menu, as the following screenshot depicts. On-demand refreshes are not included in the refresh limitation. Also note that datasets on a Premium capacity don't impose limitations for API refreshes. If you are interested in building your own refresh solution by using the Power BI REST API, see Datasets - Refresh Dataset.

Which license do you have ?

Regards,

Ritesh