Azure Data Factory cannot load from Office365

MT 136 Reputation points
2021-09-26T18:03:13.6+00:00

Hi,

I am getting the following error. Could you let me know how to resolve this?

ErrorCode=UserErrorOffice365SinkValidationError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Office365 data loading job failed to validate the sink data store. Possible causes are the name of the data store or its folder path is invalid, or the provided credentials do not have enough permission to access the folder. Detailed error: Blob operation Failed. ContainerName: mailbox, path: b/.,Source=Microsoft.DataTransfer.ClientLibrary,'

Source and Sink test connectivity runs ok and there are no Pipeline Validation errors.

Thanks,
MT

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,600 questions
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. svijay-MSFT 5,201 Reputation points Microsoft Employee
    2021-09-27T07:15:40.917+00:00

    Hello @MT ,
    Welcome to the Microsoft Q&A platform.

    I see that you are 'UserErrorOffice365SinkValidationError'. One cause could be because of the lack of Permission.

    Can you please confirm whether are you making you're making use of the Service Principal ? Also, can you confirm what is the permission level you are making use of for the Identity(Service Principal/User Principal) ?

    135397-image.png

    For sink - the basic permission level would be Storage Blob data Contributor Role.

    Access Storage Account in which Sink Blob is present --> Access Control (IAM ) ---> Search and select the principal Name --> Check whether Storage Blob Data Contributor Role is present - if not provide the role by following steps mentioned here.

    135466-image.png

    I understand that Source and Sink test connectivity runs ok and there are no Pipeline Validation errors - If I am not wrong, this checks out well if the identity accessing has a basic read permission.

    --------------

    Update :

    The contributor role may not suffice in this scenario. You would still need Storage Blob Data Contributor as mentioned in the article here.

    135577-image.png

    Please let us know if you have any queries.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators