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.
Hi,
From my understanding service display s dates/times in UTC format.
If in U.K. what is the best way to ensure dates/times always displayed in local time zone (i.e. as clocks move forward 1 hour in March) uses british summer time automtically and then switch back in October when clocks go back an hour.
Is there a setting at tenant level whereby could say all dates/times to be displayed in local time zone?
Thanks
Solved! Go to Solution.
Hi @po ,
Powerbi Service now only supports utc time, if you want to display the local time, you can create a custom column in Query Editor use DateTime.LocalNow() and #duration() function.
https://docs.microsoft.com/en-us/powerquery-m/sharpduration
For example:
DateTime.LocalNow()+#duration(0,2,0,0)
Best Regards,
Jay
Hi @po ,
Powerbi Service now only supports utc time, if you want to display the local time, you can create a custom column in Query Editor use DateTime.LocalNow() and #duration() function.
https://docs.microsoft.com/en-us/powerquery-m/sharpduration
For example:
DateTime.LocalNow()+#duration(0,2,0,0)
Best Regards,
Jay
Hi,
Thanks for confirming.
Hi @po
It depends on where do you want use and display the Time. You can use DAX or M code.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi,
Thanks for reply.
Do you have an example.
If have datetimes which stored in database as utc and want these to show in reports as the uk equivalents we could chnage these at semantic layer on database but if wanted to do this in power bi how is this best achieved?
Thans
Use Power Query, click on the calendar/text and then Using Locale
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thanks for reply
Welcome,
Did you do it? if so please mark this thread as accepted for the rest of the community
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi,
Had thought was working but was just using the cached version in service of the desktop version.
After refresh in service not working showing utc.
o.k. in desktop but not in service.
if use now() when time in u.k. is 9.30 a.m. service shows as 8:30 a.m. i..e utc time.
How can we ensure dynamcially that now(*) and similar finctions will alwys evaluate tp correct uk time all days of the year dynamically?
Thanks
If it is working in your Desktop and not in the service then check the Date/Time of your browser.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thanks for reply.
browser has english (united kingdom) and uk dates
Found this link below which looks like takes into account dst
Did you use Power Query (like the screen shot I showed you previousely) or M code to change the Date column to Locale??
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
I used locale as pre your screenshot
Great,
I would be nice to mention that reply (screen shot) as accepted solution for the rest of the community to know how to solve it.
Thanks
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi,
Tried now() function by iteslf and shos as uk time correctly in both desktop and service.
Notice is a seeting at file level which already set to uk as per below.
Is it sufficient to ensure this is set as expected without having to go into individual datetime columns and set locale there?
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |