Forum Discussion

Amoroso1909's avatar
Amoroso1909
Regular Visitor
2 years ago

Error message for Amazon S3 Bucket Connector

Hi Community,

 

I am trying to connect to an Amazon S3 Bucket ( Amazon S3 connector overview - Microsoft Fabric | Microsoft Learn ) with a data pipeline.

Unfortunately I am receiving following error message:

"An exception occurred: DataFormat.Error: Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: '=' is an unexpected token. The expected token is ';'. Line 31, position 23.)"

 

There are right now 2 CSV files and 1 Excel file in the bucket.

 

Any help to explain the issue would be highly recommendend.

Thanks in advance.

Frank

 

pipelines

12 Replies

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

    Hi Amoroso1909 

     

    Thanks for using Microsoft Fabric Community.

    Apologize for the inconvenience.

    It appears the encountered error message is related to missing IAM permissions for the user in AWS. My attempt to replicate the scenario with appropriate permissions attached via policies (directly or through groups) resulted in successful connection to the S3 bucket. For your reference, please find the screenshots.

    Without appropriate permissions: Got the same error.

    With appropriate permissions: Able to connect successfully.

    Could you please re-check your Permissions Policies under IAM in AWS and try to connect again.

     

    I hope this information helps. Please do let us know if you have any further questions.

     

    Thanks.

     

    • Amoroso1909's avatar
      Amoroso1909
      Regular Visitor
      2 years ago

      Hi v-cboorla-msft ,

       

      thanks for your fast answer. Glad that I can adress the issue now.

       

      However, the bucket itself is managed by our IT, thus I need to give them clear instructions. Is there a documentation, which rights are exactly needed or are you able to give me more details?

       

      Thansk and best regards

      Frank

       

       

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

        Hi Amoroso1909 

         

        Permissions that needs to be configured:

         

        To copy data from Amazon S3, make sure you've been granted the following permissions for Amazon S3 object operations: s3:GetObject and s3:GetObjectVersion.

        In addition, s3:ListAllMyBuckets and s3:ListBucket/s3:GetBucketLocation permissions are required for operations like testing connection and browsing from root.

         

        For more details please refer : Configure Amazon S3 in a copy activity

                                                       : Specifying Permissions in a Policy on the AWS site.

         

        I hope this information helps. Please do let us know if you have any further questions.

         

        Thanks.