web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Snowflake connector in...
Power Automate
Unanswered

Snowflake connector in Power Automate doesn't refresh OAUTH tokens

(2) ShareShare
ReportReport
Posted on by 50

Hello there,

I've been trying out the newly added Snowflake connector (https://learn.microsoft.com/en-us/connectors/snowflakeip/). After following the readme the connector itself works flawlessly, for a short amount of time. After about 2 hours of use the actions using this connection will response with "Unauthorized" and "code""390303""message""Invalid OAuth access token. ...oRif_YACXg".

 

To get it working again I need to manually go to the Connections tab and "switch connection" just to sign in again. After that the token is refreshed. This isn't of course very convenient as we are trying to automate things here. 

 

Any ideas?

Categories:
I have the same question (0)
  • chuck3138 Profile Picture
    22 on at
    Re: Snowflake connector in Power Automate doesn't refresh OAUTH tokens

     

    i guess if the user account you are using in the snowflake connector have the same email address as the Azure account you are using to login, then when Azure session expired, your snowflake connection will be disconnected too.

     

    you probably want to use API access key and secrets to create a permanent connection to the snowflake api.

     

    that's my guess

  • jigglyjiggly Profile Picture
    2 on at
    Re: Snowflake connector in Power Automate doesn't refresh OAUTH tokens

    @Dynamo We encountered the same issue. Did you manage to find a solution for it? 🙂

     

     

  • Dynamo Profile Picture
    50 on at
    Re: Snowflake connector in Power Automate doesn't refresh OAUTH tokens

    Unfortunately no, I came to the conclusion that the connector is unusable as of now and decided to build a function app for the Snowflake connection which is then used from the Flow. 

  • Nik968 Profile Picture
    2 on at
    Re: Snowflake connector in Power Automate doesn't refresh OAUTH tokens

    Facing the same issue...

  • garttim Profile Picture
    5 on at
    Re: Snowflake connector in Power Automate doesn't refresh OAUTH tokens

    I was running into this issue in our environment and came across this article - FAQ: Common Issues When Using the Snowflake Connector on Logic Apps, Power Automate and Power Apps. Specifically, this bit helped: 

    I am seeing the "Invalid OAuth access token. ...<random string>" error from the Azure side, what should I do?
    The most common cause of this error is invalid audience validation. If you have an existing OAuth integration for Power BI SSO with 'https://analysis.windows.net/powerbi/connector/Snowflake', please make sure that you add 'https://analysis.windows.net/powerbi/connector/snowflake' to the audience list:

    ALTER SECURITY INTEGRATION SF_CONNECTOR
    SET EXTERNAL_OAUTH_AUDIENCE_LIST = ('https://analysis.windows.net/powerbi/connector/snowflake', 'https://analysis.windows.net/powerbi/connector/Snowflake');

     

    In my case, we already had an integration set up in Snowflake for PowerBI which used the URL in the audience list where "Snowflake" used a capital S. I had our Snowflake admin alter the audience list to include the URL with the lowercase s and it seems to have resolved the issue.

  • Ayliac Profile Picture
    3 on at
    Re: Snowflake connector in Power Automate doesn't refresh OAUTH tokens

    Update: the solution above works! 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard