Forum Discussion

jmg80525's avatar
jmg80525
Helper II
1 year ago

Why 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...
Need Help
lbendlin's avatar
lbendlin
Super User
1 year ago

Your TIMESTAMP_TZ result is not ISO-8601 conform.  Add the T  and it will work just fine.  It will work just fine without it too, but that's besides the point.

 

 

 

 

  • jmg80525's avatar
    jmg80525
    Helper II
    1 year ago

    Could you clarify? Here's a better snapshot of what I'm seeing.  The data stored in Snowflake is cast as TIMESTAMP_TZ with the timezone being UTC(Z).  For whatever reason, PBI does not recoginzie the Snowflake data type being what it would call DateTimeZone.  Are you suggesting that the Snowflake data type TIMESTAMP_TZ is not ISO_8061 compliant?  As you can see the transformation step I applied to create PBI_TIMESTAMP_DTZ (DTZ being DateTimeZone) I simply took the DateTime value from the first column and concatenated the zone as text.  I fully realize I can transform the data into what I need.  What I want to understand is why PBI doesn't cast Snowflake TIMESTAMP_TZ as DateTimeZone when pulling data from it.  Any insights are greatly appreciated. 

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

       

      For whatever reason, PBI does not recoginzie the Snowflake data type being what it would call DateTimeZone

       

      The reason is that the incoming data assumes UTC, but does not explicitly specify it. Can you ask your data engineer to help you change the query so the timestamp comes across in proper ISO-8601 ?

       

      Or continue doing what you are doing - slap "+000"  onto the text.  Or use DateTime.AddZone