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 binary level, but I would like for it to conver to a proper SID format ex. "S-1-5-21-917267712-1342860078-1792151419-500"
If there is a way to get an objectGUID as well that would be great. But only really need the SID as of now.
Thanks in advanced!
4 Replies
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 DirectoryActive Directory ObjectGUID format - conversion
Best Regards,
AngeliaHi bson,
Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.
Best Regards,
AngeliaHey Angelia,
I have not gotten the chance to test out your solution. Once I get some time, I will let you know what worked for me, thank you :)
Hi bson,
Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.
Best Regards,
Angelia
