Forum Discussion

stvcdms's avatar
stvcdms
Frequent Visitor
9 years ago
Solved

Get Data - Active Directory Object GUID or SID

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. Anyo...
Need Help
  • stvcdms's avatar
    stvcdms
    9 years ago

    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's avatar
v-qiuyu-msft
Community Support
9 years ago

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's avatar
    stvcdms
    Frequent Visitor
    9 years ago

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