Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Bug: COPY Activity Additional Columns not populating

I have a pipeline COPY Activity where the source is a Blob Storage file (Data Lake Gen 2) and destination is either a Lakehouse Delta table or Warehouse table. None of the additional columns are being populated.

Tried with $$FILEPATH and various system variables, pipeline parameters

 

$$FILEPATH does not save properly. When I open the pipeline I see this. The Value has changed to Custom and there is an error message

 

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Thanks for using Fabric Community,

    I cannot find any bug, everything is working properly. I can also find $$FILEPATH at Value itself.

    Please find below screenshot:


    Destination Lakehouse:


    Can you please confirm your source? Is it DataLake Gen 2 Storage Account?

    Hope it is helpful. Please let me know incase of any further queries.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous ,

      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. Otherwise, will respond back with the more details and we will try to help.

      Thank You

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi,

        No I still have the problem. My UI does not show the UI but it is Azure Data Lake Storage Gen 2. My pipeline is more parameterised than your example


         

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, what do you need to know?

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous ,

      I am asking in which region you are working?

      • Anonymous's avatar
        Anonymous
        Not applicable

        uk