Snowflake Connector 2.0 - not recognising boolean data in native queries

Hi reubwork ,

Since v2 of the connector rolled out, Power BI doesn’t always recognize boolean (true/false) columns correctly from native SQL queries. Instead, you’ll get data type errors or mismatches, and sometimes reports that worked before will suddenly fail, especially if you’re not explicitly casting types in Power Query.

Here’s what you can do right now:

1. Workaround: In Power Query, right after you load your data, go to the boolean column, and manually set its type to “True/False” (Boolean). If you’re still getting errors, sometimes it helps to CAST your boolean as an INT or STRING in your SQL, then convert it to Boolean in Power Query.
   
   

2. No permanent fix (yet): Unfortunately, there isn’t a true fix right now, unless your org can somehow use the old connector version, but for most of us, v2 is enabled by default and can’t be rolled back.