Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Does anyone know if its possible to connect to AAD to pull user profile info using power BI ?
e.g. Name, Email, Job Title, Department and manager ?
Yes, there is an Active Directory connector in Power BI. Specify the domain and then select the object as needed. Be prepared for LONG waits, especially in larger companies. That thing is SLOW.
@damomac85 , did you figure out how to do this? I'm trying to do the same thing and can't find any documentation on it...
Hi @Anonymous,
I achived this by using a power bi workflow to connect to AD and refresh the data over night, as this informaion is not transactional based so does not update very oftern.
I then joined to the datasource using email address. This might not be the best/most efficient way to do this but it was enought to cover my requirement.
User | Count |
---|---|
14 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
15 | |
4 | |
3 | |
3 | |
2 |