Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Ultimately using the Office Graph API with a REST call was easier and the Office Graph ID was sufficient in this case.
Ultimately using the Office Graph API with a REST call was easier and the Office Graph ID was sufficient in this case.
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
Thanks for the reply, unfortunately the binary functions don't appear to reproduce the GUID they just generate a non-globally unique string.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |