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

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.

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