Snowflake Connector Fails in Power Query / Does Work in Workplace Connection Settings

Hi justincarter ,

Thank you for reaching out to the Microsoft Community Forum. You are facing a mismatch between “connection-level credentials” and “dataset/query editor credentials” in Power BI / Fabric with Snowflake + key pair auth + Direct cloud connections. It is not a credential problem It’s a schema mismatch causing query evaluation failure, which Power Query incorrectly reports as a credential error.

Please try below general workarounds to fix the issue.

1. Temporarily bypass schema validation: Open Power Query --> Go to Advanced Editor, modify your query to avoid immediate column dependency. Please refer below sample code.

let
Source = Snowflake.Databases(...),
Table = Source{[Name="Table"]}[Data],
#"Keep Columns Safe" = try Table otherwise Table
in
#"Keep Columns Safe"

Then Save, Re-open and fix column names step-by-step.

2. If you know the column changes, Open Advanced Editor --> Update renamed fields manually in M code: Table.RenameColumns and Table.SelectColumns. Please refer below sample code.

Table.RenameColumns(Source, {
{"old_name", "new_name"}
})

3. Go to: Dataset settings --> Data source credentials. Click Edit credentials, Re-enter key pair auth details and Save.

4. Duplicate the query (M code), Delete original Snowflake source step, Reconnect fresh and Reapply transformations.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh