Forum Discussion

manoj_0911's avatar
manoj_0911
Kudo Commander
5 months ago
Solved

Snowflake OAuth + Import Mode Refresh Behavior

When using OAuth authentication with Snowflake and Import Mode datasets, does scheduled refresh always reuse the stored OAuth credential, or does it require periodic reauthentication?

  • For import mode datasets, the refresh will use the credentials that are specified by the owner of the report.  It will use these until either the credentials change, or the report owner changes on the report.  If the same owner re-publishes and overwrites the report it will keep the saved credentials as the owner hasn't changed.

  • Scheduled refresh does not require the user to reauthenticate manually each time. You may need to reauthenticate if one of the following occurs: refresh token expiration or revocation, credential reset in Power BI, OAuth policy changes in Snowflake.

4 Replies

  • For import mode datasets, the refresh will use the credentials that are specified by the owner of the report.  It will use these until either the credentials change, or the report owner changes on the report.  If the same owner re-publishes and overwrites the report it will keep the saved credentials as the owner hasn't changed.

  • Scheduled refresh does not require the user to reauthenticate manually each time. You may need to reauthenticate if one of the following occurs: refresh token expiration or revocation, credential reset in Power BI, OAuth policy changes in Snowflake.

  • v-priyankata's avatar
    v-priyankata
    Community Support

    Hi manoj_0911 

    Thank you for reaching out to the Microsoft Fabric Forum Community.

    d_m_LNK cengizhanarslan Thanks for the inputs.

    I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.

     

    • v-priyankata's avatar
      v-priyankata
      Community Support

      Hi manoj_0911 

      Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.