Forum Discussion
OLE DB or ODBC error with Boolean Column Filter
This is a known issue with the Snowflake connector: OLE DB or ODBC error with Boolean Column Filter - Microsoft Fabric Community
Looks like it will be fixed in the October 2024 release. Besides the workaround listed, you also can use the May 2024 version of Power BI Desktop.
what are you doing with a calculated column? so do you have a combined model? i would try and push the calculated column to direct query if you can, if you have a platform what is the value of creating a calculated column in power bi? Please can you provide an actual example of what the data looks like andd the error you get, as well as your measure code, with what you expect to get.
I only created a calculated column as a workaround for this issue, since I saw that suggested in other posts. The fields are already in TRUE/FALSE type from the source (Snowflake), and I first attempted to filter the report directly with that field.
Any time a boolean field is being used in my reports, I am receiving the error I mentioned.