cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KThrane
Frequent Visitor

TimeZone confusion - correct on DeskTop / wrong on Service

Hi there

 

Do hope there are a smart person out there who once for all can help alot of us out.

 

There are multible strings relating to the same issue and none of the really fix the issue for me. Only a "stupid" workarround is getting the right date/time on to the canvas at the PowerBi Service in mine setup.

 

Case short :

On the canvas I have shown a DateTime of last refresh of data. (not the latest refresh of the view on PowerBi.Service)
On the PowerBI Desktop the refresh Date/Time is shown correctly.

On the PowerBI Service the refresh Date is OK but Time are -2 hours.

The only workarround I can find (to handle this "error" from Desktop to Service) are to add a new colum with a +2 hours:

Column 1 : = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})

Column 2 : = Table.AddColumn(Source, "Data Opdaterings Dato/Tid", each DateTime.From(DateTimeZone.FixedLocalNow()+ #duration(0,2,0,0)))

 

But this will leave me with a PowerBI Desktop version witch are "not rigth".

There must be a way for PowerBI Service to do it right without the workarround.

 

Picture below shows:

Top = PowerBI Service

Middle = PowerBI Desktop

Buttom = PowerBI Power Query.
Green = the right time. (the +2min. are do to upload time etc :-))

 

Picture to the right, show the settings on PowerBI Service.

 

Wrong timezone.jpg  Wrong timezone1.jpg

4 REPLIES 4
ibarrau
Super User
Super User

Hi. You can try converting that DateTime column in Edit Queries or Transform Data using locale. 

https://www.oraylis.de/blog/local-date-formats-in-power-bi#:~:text=Here%20comes%20the%20easy%20way,s....

That should keep it the same way.

I hope that helps 


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

KThrane
Frequent Visitor

I've tried that as well and sadly it did not make any difference.

@KThrane Is it a true statement that you are in a time zone (physically) that is not Central European Summer Time? From what I can tell, that is where your Power BI Service Tenant is provisioned?


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

I am located in Denmark witch are +1 hour from GMT and +7 from CST time.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!