Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |