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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
tanyad
Advocate III
Advocate III

Time Zones > What's happen!?!

I have no idea if this is SharePoint, PBI desktop or the service.

Issue:

  1. Automate transfers data into a SP List > in UTC
  2. View said data in SharePoint list and shows local (UK/GMT) > that's correct.
  3. Two weeks ago, I connected to the SP list from Desktop and the DateTime showed as local > that's correct
  4. Published it to the Service > DateTime showed as UTC.
  5. Banged head against wall, and decided to go for a Dataflow
  6. Copied the query from the desktop put into a Dataflow, bingo Datetime showed as local
  7. Report has been running for 2 weeks all was good.
  8. Now time's on the report are showing in UTC.

Decided to repeat the whole process, but now when I am in Desktop the DataTime is showing in UTC (step 3).  For the life of me cannot get anything to show in local.  Tried changing datetime local etc... Nothing is working.

 

Can anyone help, or is anyone having the same issues.

 

Many thanks

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@tanyad 
In desktop, now() function returns the local time, when you publish to service the now() function will return the UTC time. Unfortunately, We can't change the the time zone on Power BI Service.

 

To get time zone correct, you can add or reduce the time difference in dax, or change the timezone in power query. For detail: Solving DAX Time Zone Issue in Power BI.

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
 

 

 

 

View solution in original post

3 REPLIES 3
V-pazhen-msft
Community Support
Community Support

@tanyad 
In desktop, now() function returns the local time, when you publish to service the now() function will return the UTC time. Unfortunately, We can't change the the time zone on Power BI Service.

 

To get time zone correct, you can add or reduce the time difference in dax, or change the timezone in power query. For detail: Solving DAX Time Zone Issue in Power BI.

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
 

 

 

 

amitchandak
Super User
Super User

@tanyad , Refer if this can help

https://sharepoint.stackexchange.com/questions/264660/sharepoint-date-wrong-in-power-bi

https://community.powerbi.com/t5/Desktop/Time-Zone-Issue/td-p/646902

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Many thanks for the pointers, however when i originally built the report on the 22nd June i did not have to convert anything, i just consumed the data into a Dataflow, which then showed it as UK.  What i am wondering is what has changed in the Service in the last week or so that has changed how it handles the dates.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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