Get Data - Active Directory Object GUID or SID

[stvcdms]

Hello,

Has anyone had luck getting an AD Object GUID or SID using Power Query? I run into the issue with the result being a GUID in binary format and Power Query being unable to handle that. Anyone else have luck with this?

[stvcdms · Accepted solution]

Ultimately using the Office Graph API with a REST call was easier and the Office Graph ID was sufficient in this case.

[v-qiuyu-msft]

Hi @stvcdms,

Power Query provide many Binary functions to extract data from binary like Binary.ToList and Binary.ToText which you can try.

By the way, instead of using Power Query, you can use the Active Directory data source in desktop to get data, then in Query Editor to transform data in UI.

Best Regards,
Qiuyun Yu

[stvcdms]

Thanks for the reply, unfortunately the binary functions don't appear to reproduce the GUID they just generate a non-globally unique string.