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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Flippered
New Member

Different times displayed for report in my workspace and app workspace

I am aware of the limitations in displaying localized times in PBI service, leading to a discrepancy between the service and PBI Desktop, but I just noticed that the same report uploaded to My Workspace, which I was using for staging, and a shared App Workspace also display different times. The report was published to each workspace from the same .pbix file, minutes apart, and each was opened with the same device / browser / IP-address.

 

Does anyone know what is happening here? I've assumed that My Workspace runs in the cloud in a practically identical fashion to app workspaces, including location / timezone, but apparently that is not true. It seems that My Workspace is getting the location setting "correctly" and app workspace uses UTC, but where does each of them get their location from, and how can they be "synced"?

 

I really wish improving timezone handling was made a priority for PowerBI development. Dealing with timezones is tough enough at the backend without having to solve a whole new set of issues when reporting, and I can't be the only one who keeps running into these issues with PBI.

5 REPLIES 5
Flippered
New Member

I am aware of the limitations in displaying localized times in PBI service, leading to a discrepancy between the service and PBI Desktop, but I just noticed that the same report uploaded to My Workspace, which I was using for staging, and a shared App Workspace also display different times. The report was published to each workspace from the same .pbix file, minutes apart, and each was opened with the same device / browser / IP-address.

 

Does anyone know what is happening here? I've assumed that My Workspace runs in the cloud in a practically identical fashion to app workspaces, including location / timezone, but apparently that is not true. It seems that My Workspace is getting the location setting "correctly" and app workspace uses UTC, but where does each of them get their data from, and how can they be "synced"?

 

I really wish improving timezone handling was made a priority for PowerBI development. Dealing with timezones is tough enough at the backend without having to solve a whole new set of issues when reporting, and I can't be the only one who keeps running into these issues with PBI.

HI @Flippered,

 

Please take a look at below KB which told about time issue on power bi service.(current power bi service only support UTC format)

Time in PBI Service is inconsistent with the local time (non-UTC time) displayed in PBI Desktop

 

In my opinion, I'd like to suggest you use UTCNOW function to get local UTC time to handle time calculation.

Power BI Desktop February Feature Summary

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Thank you for your response.

 

I am aware that PBI service supports uses UTC time and the inconsistency this creates with PBI Desktop. What I'm confused about is an inconsistency between times displayed in identical reports published to "My Workspace" and an app workspace. One seems to adjust DateTimeZone-typed times to display them in UTC, the other doesn't. While this isn't a critical problem in itself, I've implemented workarounds for this several times, it makes using "My Workspace" as a staging environment risky. Again, this isn't necessarily a problem as I can create a separate app workspace for staging, but it would be good to understand what is happening and how "My Workspace" differs from app workspaces.

Anonymous
Not applicable

@Flippered 

Did you ever find an understanding of the inconsistency between My Workspace and App Workspaces?

Or even better, a solution to make App Workspaces have the same settings as My Workspace?

 

I am facing the same issue and a description of this would be highly appreciated. 

HI @Flippered,

 

I also not sure why this issue appears(I can't repro this), maybe you can open a ticket  or direct contact to power bi team to ensure this.

submit a support ticketsubmit a support ticket

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors