Forum Discussion
Import sharepoint folder gives error on recent dates
On sharepoint import of a directory, many files have broken create/modified dates. Typically they have creation dates that are recent and called things like "yesterday" in the sharepoint interface rather then dd/mm/yyyy. This is sepite they being called date/time in the sharepoint settings.
This is a hard bug in latest version and can be corrected with changing text in advanced editor from API 15 to 14.
eg:
let
Source = SharePoint.Files("https://testgroup.sharepoint.com/sites/mysite", [ApiVersion = 14])
in
Source
3 Replies
StephenF , you may follow this solution and stop auto-detect data type and handle the data type in M
This doesnt solve the problem unfortunately.
I restarted powerBi, cleared cache, even started a new project.
Both type detection and time intelligence are turned off. I'm using the august 2020 edition BTW.
DataFormat.Error: We couldn't parse the input provided as a DateTime value.
Details:
9/13/2020 7:00 PMThis is a hard bug in latest version and can be corrected with changing text in advanced editor from API 15 to 14.
eg:
let
Source = SharePoint.Files("https://testgroup.sharepoint.com/sites/mysite", [ApiVersion = 14])
in
Source
