Forum Discussion
OLEDB or ODBC error:[Expression.Error] with True/False Data Values
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.
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.
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.