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.
Hey all,
I was having an issue with data saved in our SQL Database in UTC time. We were trying to determine when schedule tasks were running most frequently, but the chart was obviously wrong from what we knew about the data:
I didn't want to apply a blanket offset of -6 or -5 (I'm in US Central Timezone) becuase, depending on daylight saving it could be one or the other.
I searched quite a bit, but eventually found the easiest solution right in the Query Editor. My data was stored as 'DateTime' so I changed the type to Date/Time/Timezone.
Then in the 'Transform' tab I simply clicked on 'Time' in the toolbar and choose 'Local Time'.
Power Query automatically applied the correct offset and my chart looked much better!
Hope this helps someone else out there~!
Solved! Go to Solution.
Hi @Anonymous,
Thanks for your sharing!
Regards,
Daniel He
Hi @Anonymous,
Thanks for your sharing!
Regards,
Daniel He
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |