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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

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