To get the user's additional information details from office 365 or ActiveDirectory for Power BI

[sinanalmac]

Hi  All, 
I have the user information data which contains e-mail addresses. Our company also uses Microsoft office365. All user information is inside of office365 needs to get the user's additional information details.

Example: department, location, Identity Type, Function, Line manager, etc.

my excel information:

S-ID	Participant Id	Full Name	UTC Event Timestamp	Action	Role
121	jack.poul@bnafem.com	Jack Poul	4/15/2020	Joined	Attendee
123	keren.Till@bnafem.com	Keren Till	4/15/2020	Joined	Attendee
128	Richard.tim@bnafem.com	Richard Tim	4/15/2020	Joined	Attendee

Is there a way to get this additional information from office365 or ActiveDirectory by looking at the email column of the excel file I uploaded into Power  BI?

[Greg_Deckler]

There is an Active Directory connector and you could also potentially connect to Azure AD Graph API.

[sinanalmac]

thank you  @Greg_Deckler 

Meh, my company doesn't allow me to use the AzureAD Grap API. But if I manage to get additional information details from excel to SharePoint via ms flow, I can solve my problem.
But I just have to figure out how to do this

Best regards

Sinan

[Greg_Deckler]

Yeah, security people, what are you going to do? God forbid anything is actually useable. I think security wonks define functional as "insecure" and completely and utterly unusable as "secure".