Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
101 | |
93 | |
69 |
User | Count |
---|---|
173 | |
135 | |
132 | |
101 | |
95 |