Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I have a series of json files that I am importing into PowerBi which correctly display the UTC date information, however when the data is being imported into Desktop, it appears that it is being read as the local time instead of the UTC time.
Can anyone suggest a way that doesn't involve DAX to correct this? I already have a DAX solution but am trying to remove the need to duplicate each date/time column to adjust for this problem.
Thank you!
Hi @cdn4lf ,
Can you refer following thread for this please:
https://community.powerbi.com/t5/Desktop/Relative-Date-in-Local-time-not-UTC/td-p/617405
If this helps please give Kudos and mark this as a Solution! 🙂
Thanks,
Pragati
This isn't a relative date issue. The data coming in is formatted at UTC "StartDate":"2020-09-21T22:15:00","EndDate":"2020-12-14T23:45:00", and there is no time zone information listed.
I already have the following dax code in use, however the goal is to not need it.
DateTimeZone.RemoveZone([EndDate])+ #duration(0,DateTimeZone.ZoneHours([EndDate]),0,0)
Hi @cdn4lf ,
Have you tried using the following in Edit Query: (right click on your Date column)
If this helps please give Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi @cdn4lf ,
Can you try the following once, if it resolves your issue: (This allows us to set our date time in multiple zones)
There is a similar thread for this:
https://community.powerbi.com/t5/Desktop/How-to-keep-source-datetime/td-p/698674
If this helps please give Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
84 | |
65 | |
62 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |