nokt3
2 months agoNew Member
Status:
New
Power BI Desktop Snowflake Refresh Fails: “Cannot Convert Null to Text” While Service Still Works
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 ...
Anonymous
1 month agoNot applicable
Hi nokt3 I've seen this "Cannot convert null to type Text" error in Desktop but not in Service before. In Desktop, the newer native Snowflake connector v2.0 is stricter with nulls compared to Service. Try these 2 fixes that worked for me: 1. Force null handling in M : Wrap your columns with null checks before loading Table. TransformColumnTypes( #"PreviousStep", {{"ColumnName", type nullable text}} ) Replace ColumnName with the columns that can be null. Or use `type nullable text` for all text columns. 2. **Cast in Snowflake SQL itself**: Instead of relying on PQ to infer types, cast in your native query ```sql SELECT COALESCE(COLUMN_NAME, '') AS COLUMN_NAME FROM VIEW_NAME Most of the time it's because 1 column started returning NULL recently and Desktop v2.155 is failing on type conversion.Since Service uses a different gateway engine, it auto-converts nulls so it still works there.Let me know if step 1 fixes it. Also try switching back to Implementation="1.0" temporarily to test. Thanks