Power BI Desktop Snowflake Refresh Fails: “Cannot Convert Null to Text” While Service Still Works

[nokt3]

Hi all, I’m seeing a sudden Power BI Desktop refresh failure with Snowflake-backed Power Query tables. Has anyone else seen this with recent Power BI Desktop / Snowflake connector builds? Is there a known regression or recommended workaround?

Power BI Desktop version: 2.155.756.0
Install type: Microsoft Store app
Connector: native Snowflake connector
Pattern: Snowflake queries fail in Desktop, but the same SQL runs successfully in Snowflake and the dataset/report still refreshes in Power BI Service.

Representative M pattern:
let
Source =
Value.NativeQuery(
Snowflake.Databases(
"<snowflake_account>",
"<warehouse>",
[Implementation="2.0"]
){[Name="<database>"]}[Data],
"<native SQL query against a Snowflake view>",
null,
[EnableFolding=true]
)
in
Source

Desktop refresh error: cannot convert the value null to type Text.

Things already tried:

• Restarted machine
• Uninstalled/reinstalled Power BI Desktop
• Cleared/re-authenticated data source credentials
• Removed [Implementation="2.0"]
• Removed [EnableFolding=true]
• Replaced select * with explicit column casts
• Tested multiple Snowflake queries/tables

[DatamirHub]

I have the same issue here https://community.fabric.microsoft.com/t5/Desktop/Snowflake-Key-Pair-Authentication-not-working-on-t... and i just reverted to the version of May and works fine

[Timo_Klein]

Problem: The passphrase cannot be empty in the newest Powerbi version! (Fill in "test" in the passphrase input field) Solution (for me): Transform data --> Data source settings --> Edit Permissions --> Edit... --> click on KeyPair to show the input fields (did not show up for me at first) --> Fill in your username, private key and "test" for passphrase.