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.

[dax]

Hi @Anonymous , 

You said that the error will show in different sheet , right? If possible, could you please check which step prompt this error,  then you could check this in M code. You could inform us the correct step and error step code. By  the way, you also could refer to @Greg_Deckler 's suggestions.

Best Regards,
Zoe Zhi

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

[Greg_Deckler]

You are using the SharePoint Folder connector?

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".