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 August 31st. Request your voucher.
Hi,
The timezone for the report server is definitely UTC. Power BI Report Server is installed and the report service has been restarted. On the client machine the time zone is GMT and daylight saving + 1 hour has just occured in the last few days. So in terms of the clock time the Report server it is one hour behind that shown on the client machine.
There is a note when setting up an email Subscription schedule on the client machine that says: 'All times are expressed in UTC +01:00 (British Summer Time)'. I am sure In previous versions of the Reports server the note would just say UTC.
Best Regards,
Rik
Solved! Go to Solution.
Hi @RomeoIndiaKilo ,
Thanks for reaching out to the Microsoft fabric community forum.
For this issue by default scheduled refresh has only allows UTC timing , as it will not having option to choose the other time zones , please raise a idea forum in the community.
In addition to that, I recommend submitting your detailed feedback and ideas through Microsoft's official feedback channels, such as the Microsoft Fabric Ideas. . Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.
Fabric Ideas - Microsoft Fabric Community
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards
Hi @RomeoIndiaKilo ,
Thanks for reaching out to the Microsoft fabric community forum.
For this issue by default scheduled refresh has only allows UTC timing , as it will not having option to choose the other time zones , please raise a idea forum in the community.
In addition to that, I recommend submitting your detailed feedback and ideas through Microsoft's official feedback channels, such as the Microsoft Fabric Ideas. . Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.
Fabric Ideas - Microsoft Fabric Community
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards
Hi @RomeoIndiaKilo ,
Thank you for reaching out to the Microsoft Community Forum.
Daylight Saving Time (DST) Impact: The note about UTC+1 indicates that the subscription scheduler is now aware of DST. This behavior aligns with changes in how Microsoft handles time zones in recent updates.
Power BI Report Server Updates: In newer versions, Microsoft has improved the time zone handling to be more dynamic, especially for users in DST regions. The system now adjusts the schedule display to reflect the current local time, including DST shifts.
Implications for Subscriptions:
Subscription Times May Shift: If you're scheduling reports based on a specific time (e.g., 8 AM), the server will interpret this in UTC, and the client-side UI reflects the DST-adjusted offset.
Potential Confusion: This can cause confusion if users expect the time to be static, not accounting for DST shifts.
Please follow below steps to handle :
1. Verify Subscription Times: Check the actual UTC times associated with your subscriptions. Compare them against what’s shown in the UI.
2. Set Explicit Time Zones (if possible): Some versions of Power BI Report Server allow you to specify time zones when setting up subscriptions. If this option is available, it can help prevent confusion.
3. Documentation: Update internal documentation to reflect that DST changes can affect report scheduling.
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank you
Hi v-priyankata
2025 January edition Email subscription Schedules work great if the workstation timezone (in this case GMT) and the Email start time expected is GMT. It converts the GMT to UTC time zone on the Report Server and is delivered as expected. What happens when Daylight saving changes? Do the Schedules need to be edited to reflect time adjustment?
If the workstation timezone is GMT and and your Scheduled time is suppose to be 6:45 PM IST (India Standard Time). I manually calculate it to be 13:15 PM UTC. Because of the Workstation timezone GMT 12:15 PM will be written as the UTC time. It include the GMT daylight saving time when IST does not use Daylight saving time.
We are a global company and need to setup email subscriptions for different timezones destined for both Company and Customer. The work around here would be to set the client workstation timezone to UTC, calculate the UTC time and use shared schedules. Idealy timezone should be included in the Schedule with start time so the UTC time can be calculated correctly.
Your thoughts?
Best Regards,
Rik