Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
arock-well
Helper V
Helper V

Bookings Calendar Showing UTC Time

A colleague of mine made a connection to a Bookings calendar to use in a Power BI report. The local pbix file seems to work as expected. However, when the report is published to the Power BI Service, the timestamps are showing what appears to be the UTC time instead of the local time.

 

For example, when I hover over a calendar event it shows the wrong Start and End time of 7 AM to 7 AM when it should be showing 12 AM to 12 AM (I'm in the Pacific time zone in the US).

 

This is correct when looking at local file:

arockwell_0-1692975682523.png

 

This is wrong when looking at same report that's been published to the Power BI Service:

arockwell_1-1692975752696.png

 

What's interesting is that when I hover over another employee's event in a different time zone it adjusts the time to whatever zone they are in. It would seem Bookings and/or Power BI are looking at the employee's time zone that's associated with them in MS 365 Exchange.

 

Any ideas what needs to happen to fix this?

2 REPLIES 2
Covenant-bi
Helper I
Helper I

The issue you are experiencing is likely due to the fact that the time zone of the Power BI Service is set to UTC. When you publish a report to the Power BI Service, the timestamps in the report are converted to UTC. This is why the timestamps in your report are showing the wrong time.

To fix this, you need to change the time zone of the Power BI Service to your local time zone. To do this, follow these steps:

  1. Sign in to the Power BI Service.
  2. Click on your profile picture in the top right corner of the screen.
  3. Select Settings.
  4. In the Settings dialog box, select the Time zone tab.
  5. Select your local time zone from the drop-down list.
  6. Click Save.

Once you have changed the time zone of the Power BI Service, the timestamps in your report should be displayed in your local time zone.

Here are some additional things to keep in mind:

  • The time zone of the Power BI Service is set per user. This means that each user will need to change their own time zone setting.
  • If you are using a shared Power BI report, you will need to change the time zone setting for each user who accesses the report.
  • If you are using a Power BI Premium capacity, you can also set the time zone for the entire capacity. To do this, you need to contact Microsoft support.

@Covenant-bi  Thanks for the reply. When I follow those steps, I can't find a "Time Zone" tab. However, if I dig further into my personal settings, I can see I'm already set to my local time zone. Is this what you were referring to?

 

arockwell_0-1692986358491.png

 

Is there another place to look? I can't find anything on the Power BI Service Tenant Settings. Is there something I need to do in Bookings?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.