glopreto's avatar
glopreto
Frequent Visitor
4 years ago
Status:
Investigating

Service Power BI Refresh error - Snowflake

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

Data Modeling

6 Comments

  • glopreto's avatar
    glopreto
    Frequent Visitor
    4 years ago

    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's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
    glopreto
    Frequent Visitor
    4 years ago

    hello Anonymous

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
    BhargavYeluri
    Regular Visitor
    3 years ago

    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 

Completed Ideas