Hi
I have a virtual dataset containing boolean columns exposed in PowerBI. I have not been able to filter on these boolean values, as the SQL generated by PowerBI is not understood br Dremio in this case (indeed, instead of passing WHERE MY_BOOLEAN = True, PowerBI sends WHERE MY_BOOLEAN in ((0)) or MY_BOOLEAN is null, to which Dremio answers : [30029]Query execution error. Details:[ VALIDATION ERROR: Values passed to IN operator must have compatible types
Do you see any alternative to transforming myself the boolean in the virtual dataset and exposing this casted value to PowerBI ?
Thanks,
Romain