Forum Discussion

sudhav's avatar
sudhav
Helper V
2 years ago

getting error while pulling data from Microosft365 to ADF/Fabric

Hi Team,

i am trying to pull the data from Microsoft 365 to ADF using Microsoft365 connector, but i am getting below error

 

ErrorCode=UserErrorOffice365DataLoaderError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Office365 data loading failed to execute. office365LoadErrorType: PermanentError. None of the users requested were valid. Ensure the users are enabled and have a valid Exchange license,Source=Microsoft.DataTransfer.ClientLibrary,'

 

 

I have done all the setup but getting above error, can some one please guide me that what i am missing here.

TIA

 

Need Help
pipelines

5 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi sudhav 

     

    Thanks for using Microsoft Fabric Community.

    Unfortunately Fabric Community only supports fabric related issues, incase if you want to resolve your issue related to Azure Data Factory (Based on the screenshot which you have provided) - please raise your issue here - Ask a question - Microsoft Q&A.

    • sudhav's avatar
      sudhav
      Helper V
      2 years ago

      Hi,

      i was getting same error in fabric as well, infact i need it in fabric only, and tried it in fabric first, but to ensure i tried again in ADF, below is the error in Fabric, please resolve it, Thankyou

       

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi sudhav 

     

    Apologies for the delay in response.

     

    As I understand that you are getting an error while pulling the data from Microsoft 365 to MS Fabric using Microsoft365 connector.

    This error occurs when the users requested are not valid, and it is recommended that the users are enabled and have a valid Exchange license.

     

    To troubleshoot the error, you can try the following steps:

    1. Make sure that the users are enabled in Microsoft 365. You can check this by going to the Microsoft 365 admin console and navigating to Users > Active users.
    2. Check the user credentials that you are using in the Microsoft365 connector. Make sure that the credentials are correct, and that the user has the necessary permissions.
    3. Make sure that the Microsoft365 connector is configured correctly.
    4. Try using a different authentication method, such as OAuth 2.0.

    You can also refer to these links for more information:

    How to create a Microsoft 365 connection

    How to configure Microsoft 365 in a copy activity

     

    I hope this information is helpful. Please do let us know if you have any questions.

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee
      2 years ago

      Hi sudhav 

       

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Microsoft Employee
        2 years ago

        Hi sudhav 


        We haven’t heard from you on the last response and was just checking back to see if the above suggestion was helpful. Please do let us know in case of any further queries.