Filtering and visualizing Kusto data in local time
Datetime values in Kusto (aka Azure Data Explorer/ADX/KQL database in Fabric) are assume to be in UTC time. In many cases users want to filter the data and see the results using their local time. This article compares different approaches to achieve this result and do it in an efficient way. The Kusto engine includes some new optimizations in this area but still caution is recommended. KQL examples that can be run on test data and are included also a paragraph and an example on how to implement in Power BI
Bookings Google Calendar Invite for Appt is in Wrong Time Zone
We have the correct time zone listed for our Microsoft Bookings account and the automated reminder emails show the correct time zone. But when customers use the automated Google Calendar invite, it is showing the wrong time zone for their appointment. It says UTC instead of PST. I believe it is because you have the time zone listed as "(UTC-08:00) Pacific Time (US & Canada)" if you change the wording from UTC to PST I believe it would fix this issue. Google is pulling the first time zone it is seeing which is currently UTC. Please fix this.
