Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data Format.error in Transform file

 

All the excel files have same formate and same sheet name. When i connect with folder it works but when i upload in sharepoint document and try to connect with sharepoint folder it shows this error. In addition, it shows error for different file in different times. For example, once for Dec-2019, another time for Feb 2019 and so on.

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I just solved it. I clicked on the hidden item box to view all the files from that folder. There was a 1kb that created a conflict.


    Removed and solved.

    • MFelix's avatar
      MFelix
      Super User
      6 years ago

      Glad you were abble to solve it.

       

      Please mark you answer as the correct one so other can benefit from it.

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    Hi Anonymous ,

     

    Without any data is difficult to give you an answer.

     

    Try to go to function and place in this case the december file and check if the transformation occurs correctly.

     

    You are refering that  this is variable and shows on different files, how are you getting the data from the sharepoint? How is the upload made?

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    If my answer has solved your issue, please mark it as a solution for others to see.
    Thanks!

     

    Best Regards,

    Giotto