How to read Active directory user’s basic details like UserName, Locations etc..-Copy these detail from Microsoft O365 to ADLS Gen2 through ADF

Question

Requirement: to read Active directory user’s basic details like UserName, Locations etc and migrate them from on premise database to cloud.

For implementing this I need to read the Active directory user details and Copy them from Microsoft O365 to ADLS Gen2 in binary format through Azure Data Factory.

While implementing this I am getting the following error:

ErrorCode=UserErrorOffice365DataLoaderError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Office365 data loading failed to execute. office365LoadErrorType: PermanentError. The tenant admin did not opt-in to Microsoft Graph Data Connect. Please ask your tenant admin to opt-in to this service. To opt-in, look for settings for Microsoft Graph Data Connect preview. Please follow the instructions on https://aka.ms/mgdcgetstarted for using Microsoft Graph Data Connect. Please reach out to dataconnect@microsoft.com if further support is needed.,Source=Microsoft.DataTransfer.ClientLibrary,'

My registered application is granted with graph permissions -user.read.all,email,user.read in order to use Graph API.

Looking forward for solution for this error.

Also other ways of implementing my requirement (i.e without using Graph API) are also welcomed.

Thanks in Advance

Answer 1

The user resource in Microsoft Graph is a hub from which you can access the relationships and resources that are relevant to your users.
First to get the list of user's please use the following API in Graph explorer:

GET https://graph.microsoft.com/v1.0/users  

Refer this DOC for more information.

Then to get the basic details of the user's :

GET https://graph.microsoft.com/v1.0/users/{id | userPrincipalName}  

Refer this DOC for more information.

----------

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".