Forum Discussion
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:
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?
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.
3 Replies
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.
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.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 RegardsMaggie