Forum Discussion

reubwork's avatar
reubwork
Resolver I
1 year ago
Solved

Snowflake data source refresh errors following July 2025 release

In case anyone else finds this. I started getting weird errors refreshing a report in the past few days.   Data source error: The credentials provided for the Snowflake source are invalid. (Source...
Need Help
  • reubwork's avatar
    reubwork
    1 year ago

    This turned out to be user error. 

     

    We're switching from using Snowflake sql login and password, to using Snowflake service users with Programmable Access Tokens. 

    When creating a PAT, you're required to specify an explicit single Snowflake role. Then, if you try and use any other role in the power query ingest it'll fail. 

     

    So, user error. 

     

reubwork's avatar
reubwork
Resolver I
1 year ago

This turned out to be user error. 

 

We're switching from using Snowflake sql login and password, to using Snowflake service users with Programmable Access Tokens. 

When creating a PAT, you're required to specify an explicit single Snowflake role. Then, if you try and use any other role in the power query ingest it'll fail. 

 

So, user error. 

 

v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

Hi reubwork ,

Thank you for the updates and for sharing the resolution. It's greatly appreciated and will be helpful to others in the community as well.

Thank you for being an active and valued member of the community. 

Best Regards,

Lakshmi