Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In Power BI desktop with a Sharepoint list as a data source, some of the data is binary (true/false) and is imported as such. After publishing this file to the service and doing a scheduled refresh, the binary true/false is changed to 0/-1. This means that any filters set to include or exclude either "true" or "false" values are invalidated, as the data now consists of "0" and "-1". Filters that clearly communicate to an end user a "true" or "false" selection are changed to a confusing option of 0 or -1.
I created a workaround by defining a custom column in M as such:
NewColumn = if([BinaryColumn] or [BinaryColumn]=-1) then "True" else "False"
This seems to work, but it also seems like this is an issue that should be corrected.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.