Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Issue with Convert to Binary

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. 

Status: New