Convert Data - Active Directory user objectSid binary to SID

[bson]

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! 

[v-huizhn-msft]

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

[bson]

Hey 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 🙂

[v-huizhn-msft]

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

[v-huizhn-msft]

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...

Active Directory ObjectGUID format - conversion

Best Regards,
Angelia