Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.