Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is there any way to refresh a report every 30 minutes in Power BI Service?
Solved! Go to Solution.
Yes. You set up a refresh schedule for every half-hour increment. See also the documentation here: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
It's worth pointing out that there's a limit of 8 refreshes per day unless you have a premium capacity, in which case you can get up to 48.
At the moment, it looks like the refresh schedule is located under the Optimize Performance dropdown in the settings.
Yes. You set up a refresh schedule for every half-hour increment. See also the documentation here: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
It's worth pointing out that there's a limit of 8 refreshes per day unless you have a premium capacity, in which case you can get up to 48.
At the moment, it looks like the refresh schedule is located under the Optimize Performance dropdown in the settings.
Yes, you can set this to every 30 minutes by updating the refresh schedule with the Power BI Rest API. There are different Urls for datasets in a group, dataflows, etc. Just pick the one you need. Below is the Url for dataset.
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/update-refresh-schedule
Sample Body:
{
"value": {
"days": [
"Sunday",
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday",
"Saturday"
],
"times": [
"06:00",
"06:30",
"07:00",
"07:30",
"08:00",
"08:30",
"09:00",
"09:30",
"10:00",
"10:30",
"11:00",
"11:30",
"12:00",
"12:30",
"13:00",
"13:30",
"14:00",
"14:30",
"15:00",
"15:30",
"16:00",
"16:30",
"17:00",
"17:30",
"18:00",
"18:30",
"19:00",
"19:30",
"20:00",
"20:30",
"21:00"
],
"localTimeZoneId": "UTC"
}
}