Forum Discussion

RLouis24's avatar
RLouis24
New Member
1 year ago
Solved

S3 Copy Data Unable to View Directory

Good Day,
I'm trying to source from a S3 Bucket into my Fabric OneLake. 
I have set up a successful managed connection that I am able to succesfully create a shortcut in my Lakehouse utilizing. 
When I try to use the same connection via a Copy Data Activity, I'm unable to see anything within the bucket/directory along with, if I try to browse once I input my directory name I get the TLS Error below:
 
The file operation is failed. A WebException with status TrustFailure was thrown. The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. The remote certificate is invalid according to the validation procedure. 
 
I have these permissions on the S3 Side:
"s3:GetObject",
"kms:Decrypt",
"kms:GenerateDataKey",
"s3:GetBucketLocation",
"s3:ListBucket",
"s3:GetObjectVersion",
"s3:ListAllMyBuckets"*
  • RLouis24's avatar
    RLouis24
    1 year ago

    It has not resolved it. I am going to just utilize spark scripts to read from the S3 shortcut instead and write to my OneLake. 

12 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi RLouis24 ,

    Thank you for using Microsoft Community Forum.

     

    Based on the TLS error you're encountering during the Copy Data activity “TrustFailure The remote certificate is invalid” the issue is due to Microsoft Fabric being unable to validate the SSL/TLS certificate presented by your S3 endpoint.

    This commonly happens when:

    • The certificate is self-signed or from an untrusted Certificate Authority (CA).
    • There's a mismatch between the certificate domain and the endpoint URL.
    • You're using a custom S3-compatible service with an unsupported certificate.

    To resolve this, please ensure your S3 endpoint uses a valid SSL certificate from a trusted CA, and that the endpoint domain matches the certificate. If you’re behind a firewall or using SSL inspection, verify that no intermediary certificates are causing the trust issue.

    As a temporary workaround, you can manually enter the full file path in the Copy Data activity instead of using the browse option.

    For more guidance, refer to the following documentation : setting up Amazon S3 connections.

     

    I hope this will reslove your issue, if you need any further assistance, feel free to reach out.

     

    If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

     

    Thankyou.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi RLouis24 ,

       

      May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

       

      Thank you.

      • RLouis24's avatar
        RLouis24
        New Member

        Good Morning, no this did not solve the issue. Thank you for the effort though!

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi @RLouis24 ,

     

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

     

    Thank you.

    • RLouis24's avatar
      RLouis24
      New Member

      It has not resolved it. I am going to just utilize spark scripts to read from the S3 shortcut instead and write to my OneLake. 

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi RLouis24 ,

         

        Thank you for your confirmataion, may I ask if you have resolved this issue by using spark scripts? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

         

        Thank you.

  • harrybao0901's avatar
    harrybao0901
    Frequent Visitor

    I am facing the same issue, I am able to create shortcut but can not use the same S3 connection in Copy data activity, it showed certificate SSL error. Anyone know how to fix this ?

  • I'm trying to copy data from S3 into Fabric Onelake using copy Data , but i get a TLS  TrustFailure error and cannot browse bucket.

    The same connection Works for Lakehouse shortcuts.

    Any idea how to fix this?