There’s a few things you need to pay close attention to when setting the refresh schedule via the API:
– Unless you’re setting the refresh schedule for a Premium workspace, you can only refresh a dataset up to 8 times a day. We’re only going to set it to update once a day here, but keep this in mind if you’re planning to adjust the API call to refresh multiple times a day.
– The name of the time zone you provide has to match exactly with the names (middle column) in this reference: Microsoft Time Zone Index
– The refresh time has to be in the format hh:mm, and similar to the options in the Power BI portal you can only refresh on the hour or half-hour.
Read on to see how it works and the API call to make.