The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.