Forum Discussion

Sache-in's avatar
Sache-in
Frequent Visitor
4 years ago
Solved

Power BI TimeStamp refresh issue

I am trying to refresh the model build using the snowflake view from the power BI file. I am getting the below error. Please help me to fix the issue

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Sache-in ,

     

    I think you can try the workaround as below.

    Two options

    1. Run SHOW PARAMETERS LIKE 'ODBC_QUERY_RESULT_FORMAT'

    1. See if this option says value is "ARROW"
    2. If ARROW, run ALTER USER SET ODBC_QUERY_RESULT_FORMAT='JSON'

    2. If that did not work, contact Snowflake support to set ODBC_TREAT_DECIMAL_AS_INT=false in the server properties.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Sache-in ,

     

    I think you can try the workaround as below.

    Two options

    1. Run SHOW PARAMETERS LIKE 'ODBC_QUERY_RESULT_FORMAT'

    1. See if this option says value is "ARROW"
    2. If ARROW, run ALTER USER SET ODBC_QUERY_RESULT_FORMAT='JSON'

    2. If that did not work, contact Snowflake support to set ODBC_TREAT_DECIMAL_AS_INT=false in the server properties.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.