Forum Discussion

EithneDangan's avatar
EithneDangan
Regular Visitor
5 years ago

Date Errors when loading Files from SharePoint folder into Power Query

Hello everyone.   I would love some help.  I am using powerquery to load files from a SharePoint folder.  Any files uploaded since March 17th (St. Patricks Day - Luck of the Irish!) are coming in w...
Need Help
EithneDangan's avatar
EithneDangan
Regular Visitor
5 years ago

Thanks HotChilli

I have cleared folder and only have 1 file which I load dated March 27,2021.  File loads, but still getting the issue.  Apparently there was a Windows update.  I have reached out to some MVP's.  GET DATA from SHAREPOINT folder addeding an API 15 parameter at end of M-CODE for source.  It was suggested to remove this, which does remove date ERRORS but doesnt allow load.  I changed the API 15 to 14 and same result.  I have included details here

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  EithneDangan ,

 

Pls check whether there are some extra space at the front of your date column,see the similar thread below:

https://community.powerbi.com/t5/Desktop/DataFormat-Error-We-couldn-t-parse-the-input-provided-as-a/td-p/84355

Or refer below can help:

https://community.powerbi.com/t5/Desktop/We-couldn-t-parse-the-input-provided-as-a-DateTime-value/td-p/1254743

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!