Forum Discussion
Convert Data - Active Directory user objectSid binary to SID
Hey there, New to Power BI and data analytics. I would like to extract the objectSid from the records that I've pulled from Active Directory. I was able to extract everything down to the bina...
Hi bson,
In Query Editor, please use Binary.ToText function and check if it works fine, like the following shows.
= Binary.ToText(Guid, 0)
Please refer to this similar thread. You have convert the data to binary level? I test it, it display as Hexadecimal String Form as follows.
I post some blog links below. Hope it is useful.
How To Convert a String Formatted GUID to a Hexadecimal String Form For Use When Querying the Active Directory
Active Directory ObjectGUID format - conversion
Best Regards,
Angelia