Forum Discussion
Microsoft EmployeeFabric Snowflake connector returns "Invalid credentials" with Key-Pair despite valid key pair
Thank you v-saisrao-msft , I found the issue, in the connection it converted the server name to lower case although I added it in upper case, so when I used the lower case in the dataflow gen2 connection the connections I created in Settings > Manage Connections and Gateways appeared in the dropdown list. Thank you for your support
Community SupportHi melsheikh,
Since the Key-Pair connection works in Copy Job, the authentication is valid. For Dataflow Gen2, the documentation supports using the Power Query Online → Get data experience to create the connection and supports Key-pair authentication there. If the connection still isn't available or usable in Dataflow Gen2 through the documented flow, consider raising a Support ticket so the backend team can investigate the issue.
Set up your Snowflake database connection - Microsoft Fabric | Microsoft Learn
Data source management - Microsoft Fabric | Microsoft Learn
Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn
Thank you.
Microsoft EmployeeThank you v-saisrao-msft , I found the issue, in the connection it converted the server name to lower case although I added it in upper case, so when I used the lower case in the dataflow gen2 connection the connections I created in Settings > Manage Connections and Gateways appeared in the dropdown list. Thank you for your support
- v-saisrao-msft
Hi melsheikh,
As the issue is resolved, please accept the solution that helped resolve the issue. This will also help other community members who may face a similar issue in the future.Thank you.