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.
I have a Dynamics CRM database (On-Premise), where I would like to retrieve Activities (Appointment, Task...), these time entries are saved as UTC timezone.
How can I show them in Power BI in the timezone of the user Owning these activities?
Your support is so much appreciated.
Best regards,
Hayman
Solved! Go to Solution.
Hi @haymanezzeldin,
To convert UTC date to local timezone, you can use DateTime.AddZone function which adds the timezonehours as an offset to the input datetime value and returns a new datetimezone value. Then, use DateTimeZone.SwitchZone function to change the timezone information for the input DateTimeZone.
Here is a similar thread, please refer to it for detailed steps: Convert UTC to client time zones?
By the way, to change the locale settings in Power BI desktop, please refer to: Choose the locale of a report in Power BI Desktop
Best regards,
Yuliana Gu
Hi @haymanezzeldin,
Have you resolved your problem? If yes, please mark the corresponding reply as an answer so that more community members can benefit from it. If you still have any question, please feel free to ask.
Regards,
Yuliana Gu
Hi @haymanezzeldin,
To convert UTC date to local timezone, you can use DateTime.AddZone function which adds the timezonehours as an offset to the input datetime value and returns a new datetimezone value. Then, use DateTimeZone.SwitchZone function to change the timezone information for the input DateTimeZone.
Here is a similar thread, please refer to it for detailed steps: Convert UTC to client time zones?
By the way, to change the locale settings in Power BI desktop, please refer to: Choose the locale of a report in Power BI Desktop
Best regards,
Yuliana Gu
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 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |