This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA 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.
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.