# Filtering on boolean values from PowerBI

**URL:** <https://community.dremio.com/t/filtering-on-boolean-values-from-powerbi/900>\
**Category:** Uncategorized\
**Created:** [March 22, 2018, 5:54am UTC](https://community.dremio.com/t/filtering-on-boolean-values-from-powerbi/900 "2018-03-22T05:54:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![romain](https://avatars.discourse-cdn.com/v4/letter/r/c2a13f/32.png) [@romain](https://community.dremio.com/u/romain)\
**Post date:** [March 22, 2018, 5:54am UTC](https://community.dremio.com/t/filtering-on-boolean-values-from-powerbi/900/1 "2018-03-22T05:54:31Z")

</div>

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