Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Using the PowerBI Query Editor...
I've first loaded a list of files from a folder:
>> = Folder.Files("...")
Then expanded the Attributes column:
>> = Table.ExpandRecordColumn(..., "Attributes", ...)
Now, with columns/fields having string values like "TRUE" and "FALSE"; using Change Type to Binary results in an error that fills every data cell in the column:
"""
DataFormat.Error: We couldn't convert to Binary.
Details:
TRUE
""" or """
DataFormat.Error: We couldn't convert to Binary.
Details:
FALSE
"""
I've tried a workaround by converting these "TRUE/FALSE" strings into numbers (they go to 1/0) and then converting the numbers into binary. That also gives an error:
"""
DataFormat.Error: We couldn't convert to Binary.
Details:
1
"""
Issue Summary:
Unable to convert 1/0 (numeric) or "TRUE/FALSE" (string) into a binary type.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.