Forum Discussion
Snowflake cloud connection: KeyPair authentication
Hi to all,
Quick update on this issue (Key-Pair authentication between Snowflake and Power BI).
Finally got a “solution” from the support and was able refresh the model using Key-Pair authentication.
What I ended up doing is to enable “Use legacy Snowflake connector implementation” within Preview features.
According to Microsoft support: “Currently, Implementation 2.0 consumes more memory, which the engineering team is actively working to optimize. This issue has been documented in the reference document below, and the document will be updated once the fix is implemented and released”.
Thank you.
Hi ustas55 ,
Error "Resource Governance" usually denotes that a memory threshold was passed during the processing/refresh of your data, and we never see that associated with authentication as much as how big the data is or how complicated the query is.
Solved: Error: Resource Governing - Microsoft Fabric Community
Go back to use PAT/User/Password method temporarily for testing in order to ensure the model still updates successfully. This removes the problem to entirely be in our Key Pair auth setup.
Thank you Mohit.
that's exactly what we did, switch the model to use PAT user and model refreshed successfully. I assume that keypair authentication in the cloud is not fully functional?