OLEDB or ODBC error:[Expression.Error] with True/False Data Values

[Navman]

OLEDB or ODBC error:[Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.

I have started getting this error recently when I am connecting my powerbi with Snowflake table via direct query.  This is only happening with the fields which has TRUE/FALSE values.  Has anybody encountered similar issues?

[TheDAXShepherd · Accepted solution]

It is the same issue as this one: Solved: Re: OLE DB or ODBC error with Boolean Column Filte... - Microsoft Fabric Community . You can use the May 2024 version of Power BI Desktop or hopefully the October 2024 version will be released soon and contain the fix.

[Navman]

Hi @  rajendraongole1,

Thank you for the reply. There are no complex queries.  It is only connecting to the Snowflake Table via direct query.  It was working fine.  This is a 6 months refresh dashboard so only looking at it after April.  It was working absolutely fine in April. 

Regards

Nav

[rajendraongole1]

Hi @Navman -Review any transformations or filters you have applied to the fields with TRUE/FALSE values. Simplifying these expressions can sometimes resolve the folding error.Instead of using complex conditional logic, try creating a simpler version of your query that only retrieves the necessary fields without additional transformations.

Ensure that the data types in Snowflake align with what Power BI expects. The TRUE/FALSE values should ideally be represented as boolean types in Snowflake.If the fields are stored as strings or other types, consider converting them to boolean before connecting them to Power BI.

You can use the "View Native Query" option in Power Query to see if your query can be folded. If it cannot, you might need to adjust your transformations.

Check the above points still issue exists, please provide a more detailed example of your query or the specific transformations being applied may help in further diagnosing the problem.

[TheDAXShepherd]

As of the September 2024 release of Power BI Desktop - you cannot see the "View Native Query" if the source is Snowflake. It is grey for all steps.