Power BI TimeStamp refresh issue

[Sache-in]

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

[Anonymous · Accepted solution]

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.