Data Format.error in Transform file

[Anonymous]

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.

[v-gizhi-msft]

Hi,

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

Best Regards,

Giotto

[v-gizhi-msft]

Hi,

Hope this helps:

https://community.powerbi.com/t5/Desktop/File-contains-corrupted-data/td-p/548620 

Best Regards,

Giotto

[Anonymous]

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]

Glad you were abble to solve it.

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

[MFelix]

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?