DataFormat.Error - Date Created data from sharepoint imported with errors, doesn't work as type any

[Erf19]

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:

For some files, it reads the 'Date Modified' and 'Date Created' columns correctly. Unfortunately it doesn't read it correctly for any of the files I need it to read from - when I change the type to text or to any (see below) it still doesn't work.

If I click on the error it tells me this:

So the data is there, but it still tries to read it as DateTime value and not as text/any value even after changing its type.

Can someone help please?

[v-juanli-msft]

Hi @Erf19 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?

If not, please feel free to let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

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.

[artemus]

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.