Forum Discussion
jmg80525
Helper II
Helper IIWhy does Power BI not recognize Snowflake TIMESTAMP_TZ as DateTimeZone
I have worked with the data engineer to ensure that timestamp data being pipelined into Snowflake is cast as Snowflake's TIMESTAMP_TZ data type; the equivilent, I assume, of DateTimeZone in SQL Sever...
I'm sure you know that Z is for ZULU time. But perhaps Power Query is changing it to your local time zone.
--Nate
jmg80525Helper II
Helper III didn't know that Z meant Zulu and I didn't realize the each hourly offset from the Prime Meridian is also represented by a letter. HT to Wikipedia.
I'm in MST -7 (T, Tango) with my Power BI Desktop running on a local laptop, but I am VPNed to the corp office which is in CST -6 (S, Sierra). (Sorry, had to employ my newly learned knowledge:) I have no idea why it would choose -6 when casting to DateTimeZone in Power Query.