Forum Discussion
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
- d_m_LNKSuper User
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.
- cengizhanarslanSuper User
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-priyankataCommunity 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-priyankataCommunity 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.