Service Power BI Refresh error - Snowflake

[glopreto]

Data source error: DataSource.Error: <pii>ODBC: ERROR [22007] [Microsoft][Support] (40490) Invalid date, time or timestamp value.</pii>. DataSourceKind = <pii>Snowflake</pii>. DataSourcePath = <pii>ga66160.us-east-1.snowflakecomputing.com;BI_WH</pii>. OdbcErrors = <pii>#table({"SQLState", "NativeError", "Message"}, {})</pii>. . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Finance MRR Transactions.
Cluster URI: WABI-US-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 
Request ID: 
Time: 2022-04-01 08:16:52Z

Desktop is fine, problem is only when trying to refresh service. (The table changes in every try).

[glopreto]

All the steps suggested here was already done...

This is power bi service, connecting direclty to snowflake using native connector.

Import mode: Dual


quote:"

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."

Option one didnt worked... 
I also have a ticket opened for sknowflake.

[Anonymous]

Hi @glopreto ,

Please check if the following two options will help you with your problem

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,
Community Support Team _ Caitlyn

[glopreto]

hello @Anonymous

This was already done and mentioned in the previous message and it didn`t worked.

[Anonymous]

Hi @glopreto ,

Sorry for my miss.

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

Best Regards,
Community Support Team _ Caitlyn

[BhargavYeluri]

Hi @glopreto @Anonymous , 

I have the same issue here and reaching out to see if there was any working solution proposed for this. 

Thanks,

Bhargav