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.
Hi reubwork ,
Thanks for sharing this just trying to better understand your setup so I can offer the right troubleshooting steps. You mentioned the Snowflake refresh is failing in Power BI Service with a credentials error, but it's working fine locally. Just to clarify a few things: are you connecting to Snowflake using OAuth, username/password, or some other method? Are you using a gateway for the dataset, and if so, is it an on-premises or personal gateway? Also, when you say it works locally, do you mean in Power BI Desktop, and does the refresh succeed there without any issues? Did you recently update or republish the report using the July 2025 version of Power BI Desktop? And finally, have you tried re-entering or updating the data source credentials in Power BI Service after the issue started? The reason I ask is that the Snowflake Connector 2.0 just went GA with the July release, and it might have introduced some changes that impact existing configurations, especially around authentication. A bit more info would really help us narrow this down.
We truly appreciate your continued engagement and thank you for being an active and valued member of the community.
We look forward to hearing from you.
Best regards,
Lakshmi
Hi reubwork ,
I wanted to follow up and confirm whether you’ve had the opportunity to review the information we provided. If you have any questions or need further clarification, please don’t hesitate to reach out.
We truly appreciate your continued engagement and thank you for being an active and valued member of the community.
We look forward to hearing from you.
Best regards,
Lakshmi
Hi reubwork ,
I just wanted to check if your issue has been resolved. If you still have any questions or need help, feel free to reach out I’m happy to assist.
Thank you for being an active part of the community. Looking forward to hearing from you!
Best regards,
LakshmiHi reubwork ,
I just wanted to check if your issue has been resolved. If you still have any questions or need help, feel free to reach out I’m happy to assist.
Thank you for being an active part of the community. Looking forward to hearing from you!
Best regards,
Lakshmi