Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |