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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
po
Post Prodigy
Post Prodigy

Universal setting to display all time in local time zone (BST/U.K. time)

Hi,

 

We currently get supplied date/times in UTC format from a system and have to convert these to BST in the database so times display in required U.K. format.

 

I believe power bi service still displays times in UTC format.

 

Is there a simple one setting way for power bi service to disaplay all UTC times in BST/U.K, time without having to convert each and every time to BST either at database level or in power bi itself with separate measure

 

Thanks

 

2 REPLIES 2
v-zhangti
Community Support
Community Support

Hi, @po 

 

You can try to change the date format by setting the region in Power BI Desktop-File-Options and settings-Options-Regional Settings.

vzhangti_0-1653880097275.png

You can also refer to the following links, which I hope will help you.

https://community.powerbi.com/t5/Service/Incorrect-Time-Zone-setting-at-Power-BI-Service/m-p/2345344 

https://www.thepoweruser.com/2019/10/21/handling-different-time-zones-in-power-bi-power-query/ 

 

Best Regards,

Community Support Team _Charlotte

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

 

Hi,

 

Thanks for reply and links.

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors