Forum Discussion

julsr's avatar
julsr
Continued Contributor
1 month ago
Solved

First refresh fails after switching Snowflake connection from Username/Password to Key Pair

Hi everyone,

I'm looking for help with a Snowflake refresh issue in Power BI Service after changing the authentication method for our cloud connection.

Context

  • Semantic model: Large import model in Power BI Service
  • Data source: Snowflake (GOLD schema / warehouse views)
  • Refresh mode: Incremental Refresh
  • Connection type: Cloud connection
  • Gateway: Not used for this model
    • Use an On-premises or VNet data gateway is Off
    • Snowflake is mapped directly to the cloud connection

Previously, the Snowflake connection used Username + Password authentication.

  • The first historical load was slow (~4 hours), but it completed successfully
  • Incremental refresh worked after that

I switched the connection to Key Pair authentication but after that change, the first load fails with this error:

 
Processing error: The current operation was cancelled because another operation in the transaction failed. DataSource.Error: [Snowflake] arrow/ipc: could not read message body: read tcp 00.0000.0000.00>00.0000.0000.00: wsarecv: An existing connection was forcibly closed by the remote host.The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.The command has been canceled.
 
 
Has anyone else seen this exact error after switching from Username/Password to Key Pair on a large Snowflake import model? How can I solve it?
Need Help
Show and Tell
Tips and Tricks

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    1 month ago

    Hi julsr 

     

    can you make sure that when the refresh starts you can see it being executed in your Snowflake instance. If it is not getting to a Snowflake instance then potentially it there is some authentication issue which is causing it not to refresh successfully

    • julsr's avatar
      julsr
      Continued Contributor
      1 month ago

      Hello Gilbert!

       

      Yes, the refresh is being executed in Snowflake.

  • GilbertQ's avatar
    GilbertQ
    Super User
    1 month ago

    Hi julsr 

     

    so you can see that the query is being sent to Snowflake and is running successfully if you can please confirm this, because then it appears that you might need to cheque your semantic model

    • julsr's avatar
      julsr
      Continued Contributor
      1 month ago

      No, everything is good in my Semantic Model and the connections with Snowflake. However, I found in forums that multiple people are seeing DataSource.Error: [Snowflake] arrow/ipc: could not read message body during large import refreshes with Snowflake Key Pair authentication in Power BI Service.
      This appears related to the known ADBC/Arrow IPC issue documented in SNOW-3449105.
      Username/Password worked previously, but Key Pair forces ADBC per Microsoft documentation.

      So probably this is what's happening to me too: https://community.fabric.microsoft.com/t5/Service/Snowflake-ADBC-connector-error-Error-ADBC-Snowflake-arrow-ipc/m-p/5196594

      I'll raise a ticket and see how it goes. 

       

      Thanks!