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
pborah
Continued Contributor
Continued Contributor

How to force visuals in the service to display local time as opposed to UTC?

I have a card visual in a report in the service that displays current date and time using TODAY().

pborah_0-1606423624831.png

 

In Power BI desktop this displays the local time correctly. However in the service it switches to UTC. I understand that PBI service is always on UTC time. What would be an appropriate way to handle this using DAX so that even on the service the time shown on that card visual is local time and not UTC? Thank you.

 

P.S. I'm not sure if I should have posted this question in the Service thread as opposed to Desktop. If this belongs in service, admins and moderators, please feel free to reassign. Thank you.

 

 

1 ACCEPTED SOLUTION
pborah
Continued Contributor
Continued Contributor

4 REPLIES 4
pborah
Continued Contributor
Continued Contributor

this worked perfectly so long as the data connection through the gateway is setup.

 

https://community.powerbi.com/t5/Desktop/How-to-Get-Last-Refreshed-Date-in-local-DST-time-in-5-click...

amitchandak
Super User
Super User

pborah
Continued Contributor
Continued Contributor

@amitchandak that is incorrect. 

Nathaniel_C
Super User
Super User

Hi @pborah ,
You might look at this blog, I just saw this recently.
https://radacad.com/showing-current-time-and-latest-refresh-time-at-local-timezones-in-the-power-bi-... 

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors