Forum Discussion
Snowflake data source refresh errors following July 2025 release
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.
I'm facing this exact same issue. We're using snowflake cloud. It works fine on PBI Desktop and fails when published that too at random times. And corrects itself after sometime. We don't use SSO logins we use global usernames with assigned roles / service accounts. Can you share what could be causing this?
hi there,
I've had a lot of issues with the server side refresh of snowflake queries (not locally)... up until the July release which is a big improvement.
If you're using SQL Logins and passwords... you need to get off that this year as Snowflake are disabling logins without MFA.
So we've switched to using Programmable Access Tokens... https://docs.snowflake.com/en/user-guide/programmatic-access-tokens
The intermittent thing is strange and suggests some kind of data handling issue to me... I've not seen any network transport issues. (Is your power bi capacity in the same region as Snowflake?)
You can force it to use the old connector with the Implementation option. default is the new version which is 2.0
// declare connection
snowflake_connection = Snowflake.Databases(
"sonovate.west-europe.azure.snowflakecomputing.com",
warehouse_name,
[Role = role_name, Implementation="1.0"]
),
Using [Implementation="2.0"] solved my issue. Thanks!
I had other data sources along with snowflake and only those reports were failing. After forcing this in power query the refresh are working fine.
Thanks!