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.

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.