topic Re: getting error while pulling data from Microosft365 to ADF/Fabric in Pipelines

getting error while pulling data from Microosft365 to ADF/Fabric

sudhav — Tue, 17 Oct 2023 10:21:05 GMT

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

Re: getting error while pulling data from Microosft365 to ADF/Fabric

v-cboorla-msft — Tue, 17 Oct 2023 14:58:20 GMT

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.

Re: getting error while pulling data from Microosft365 to ADF/Fabric

sudhav — Wed, 18 Oct 2023 11:11:21 GMT

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

Re: getting error while pulling data from Microosft365 to ADF/Fabric

v-cboorla-msft — Fri, 27 Oct 2023 06:14:00 GMT

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:

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.
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.
Make sure that the Microsoft365 connector is configured correctly.
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.

Re: getting error while pulling data from Microosft365 to ADF/Fabric

v-cboorla-msft — Mon, 30 Oct 2023 06:03:38 GMT

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 .

Re: getting error while pulling data from Microosft365 to ADF/Fabric

v-cboorla-msft — Tue, 31 Oct 2023 17:04:12 GMT

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.