reubwork
Resolver I
1 year agoStatus:
New
May 25 update for Snowflake Connector v2 has broken native queries involving boolean data
Since the May release, any native query using a Snowflake Connector v2.0 connection experiences boolean type conversion errors on refresh.
let
Source = Snowflake.Databases("<snowflake account url>","<warehouse name>",[Implementation="2.0"]),
data = Value.NativeQuery(
Source{[Name = "<database name>",Kind="Database"]}[Data],
"select false as v union all select true as v"
, null
, [EnableFolding = true]
)
in
data
The preview in Power Query is fine, but the error is presented when dataset is refreshed.
Additionally, converting the datatype in power query doesn't work.
I suspect a workaround will be to convert the data to 1,0 values either in the snowflake query or via a text step in powerquery
This seems to be, though, to be an unintended and relatively serious breaking change.
3 Comments
- aaron_toledoNew Member
I am experiencing the same issue. Converting to 0,1 does fix the problem but is not ideal as an extra step. Another option that seems to work is removing the Implementation="2.0" setting
- reubwork
Resolver I
Yes, reverting to Implemenation=1. 0 works also. The trouble is that as of the March 25 release v2.0 is enabled by default in the options... so the boolean issue is now a breaking change. - reubwork
Resolver I
Apparently this is now resolved in the July 2025 release. Not tested it personally yet, but I assume this is now fine. https://powerbi.microsoft.com/en-us/blog/power-bi-july-2025-feature-summary/#post-30545-_Toc203388701