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 Experts,
I have datasource from Sharepoint online list where the timezone is in UTC +10, after i imported the data i shows the date field in the table is showing as UTC +0, i have to report the data in UTC +10 timezone only, is there any easy way to convert the timezone or fix the timezone in Power bi,
Solved! Go to Solution.
Hi @nagoor ,
You could try the following codes in query editor:
[DateTime] + #duration(0,10,0,0)
There two methods worked on my side.
Hi @nagoor ,
You could edit the timezone manually.
1. DAX:
Column =
'Table'[Your timezone data]+ 10/24
2. Power query
DateTimeZone.SwitchZone([Your timezone data],10,0)
Thanks it worked in Power Query, but its working fine when its in Desktop if i piblished the same, i'm still getting the UTC +0 time only 😞 anything would help me on this
Desktop - Time zone changed
Web - Time Zone Not changed
Hi @nagoor ,
You could try the following codes in query editor:
[DateTime] + #duration(0,10,0,0)
There two methods worked on my side.
@nagoor , refer , if these can help
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |