Forum Discussion
Solved
DataFormat.Error - Date Created data from sharepoint imported with errors, doesn't work as type any
I have a dataset that I replace regularly and would like a timestamp on the report to show when this file was last created. The source comes from a sharepoint folder and looks like this on import...
Hi Erf19
If "Type Detection" is checked by default, power bi will change the column type automatically when data is imported.
Please uncheck this selection, then close your file and reopen a new file.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It sounds like the values are being parsed in the day/month/year format, which would mean that it fails when the month is out of range. To fix this, choose the bottom "Use locale" option when changing column type.