The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi guys, I have a question about scheduled refreshes, I have set some PowerBI service reports to auto refresh at certain times but they seem to be an hour off - I'll set a refresh for 5 at the end of the working day and it will refresh at 4. This is because UK (London) isn't actually UTC+00:00, it's UTC+01:00 for British Summer Time. Can this not be automatically updated to change throughout the year? Otherwise I can just use a different timezone but it seems bad for the listed London timezone to be incorrect. I've noticed this is happening on SharePoint too.
Solved! Go to Solution.
Hi @louisatkin ,
You're absolutely right to point this out. The issue you're encountering with Power BI scheduled refresh times being an hour off is due to the platform using the base UTC offset for the selected time zone without accounting for daylight saving time (DST). While the "UTC Dublin, Edinburgh, Lisbon, London" time zone is listed as UTC+00:00, it does not automatically adjust to UTC+01:00 for British Summer Time (BST).
This can be misleading and cause confusion, especially in the UK during the summer months. Unfortunately, Power BI and similar Microsoft services like SharePoint do not currently adjust for DST automatically in their scheduling logic—meaning they follow static UTC offsets year-round. To work around this, you'll either need to manually adjust your refresh schedule during BST or temporarily switch to a time zone that reflects UTC+01:00. Hopefully, Microsoft will address this inconsistency in future updates to avoid these types of scheduling errors.
Hi @louisatkin ,
You're absolutely right to point this out. The issue you're encountering with Power BI scheduled refresh times being an hour off is due to the platform using the base UTC offset for the selected time zone without accounting for daylight saving time (DST). While the "UTC Dublin, Edinburgh, Lisbon, London" time zone is listed as UTC+00:00, it does not automatically adjust to UTC+01:00 for British Summer Time (BST).
This can be misleading and cause confusion, especially in the UK during the summer months. Unfortunately, Power BI and similar Microsoft services like SharePoint do not currently adjust for DST automatically in their scheduling logic—meaning they follow static UTC offsets year-round. To work around this, you'll either need to manually adjust your refresh schedule during BST or temporarily switch to a time zone that reflects UTC+01:00. Hopefully, Microsoft will address this inconsistency in future updates to avoid these types of scheduling errors.