Home

Data Format Error: We couldn't parse the input provided as a Date value

%3CLINGO-SUB%20id%3D%22lingo-sub-753731%22%20slang%3D%22en-US%22%3EData%20Format%20Error%3A%20We%20couldn't%20parse%20the%20input%20provided%20as%20a%20Date%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753731%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%206%20different%20reports%20that%20I%20receive%20daily.%20I%20am%20trying%20to%20merge%20them%20using%20power%20query%20into%20one%20table%2C%20so%20that%20all%206%20of%20the%20reports%20(only%201%20row%20of%20data%20each)%20are%20combined%20into%20one%20row%20on%20the%20merged%20table.%20I%20keep%20getting%20the%20error%20message%3A%26nbsp%3BData%20%22Format%20Error%3A%20We%20couldn't%20parse%20the%20input%20provided%20as%20a%20Date%20value%22.%20The%20Query%20connections%20seem%20to%20be%20fine.%20Then%20I%20add%20new%20files%20to%20the%20folder%20I%20am%20merging%20from%20and%20then%20I%20get%20that%20message%20when%20I%20go%20to%20refresh%20the%20query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help!!!%20What%20do%20I%20need%20to%20do%20to%20fix%20this%20error%3F%20What%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-753731%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-753874%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Format%20Error%3A%20We%20couldn't%20parse%20the%20input%20provided%20as%20a%20Date%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753874%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F375958%22%20target%3D%22_blank%22%3E%40purpleorchid%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMost%20probably%20that's%20literally%20what%20the%20message%20says%20-%20in%20one%20of%20your%20files%20there%20is%20the%20value%20which%20is%20expected%20as%20Date%2C%20but%20can't%20be%20converted%20into%20the%20date.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754121%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Format%20Error%3A%20We%20couldn't%20parse%20the%20input%20provided%20as%20a%20Date%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754121%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20double%20and%20triple%20checked%20all%20data%20before%20I%20did%20the%20query%20and%20the%20query%20refresh.%20All%20date%20columns%20were%20already%20set%20up%20as%20dates%20on%20the%20original%20worksheets%2C%20before%20I%20even%20created%20the%20query%20and%20when%20creating%20the%20query%20I%20made%20sure%20to%20set%20that%20column%20as%20a%20date%20as%20well%2C%20so%20there%20was%20nothing%20that%20needed%20to%20be%20'converted'%20to%20a%20date%2C%20as%20they%20already%20were%20dates.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754898%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Format%20Error%3A%20We%20couldn't%20parse%20the%20input%20provided%20as%20a%20Date%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754898%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F375958%22%20target%3D%22_blank%22%3E%40purpleorchid%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20provide%20the%20sample%20keeping%20only%20column(s)%20with%20dates%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
purpleorchid
New Contributor

Hi, I have 6 different reports that I receive daily. I am trying to merge them using power query into one table, so that all 6 of the reports (only 1 row of data each) are combined into one row on the merged table. I keep getting the error message: Data "Format Error: We couldn't parse the input provided as a Date value". The Query connections seem to be fine. Then I add new files to the folder I am merging from and then I get that message when I go to refresh the query.

 

Please help!!! What do I need to do to fix this error? What am I doing wrong?

3 Replies
Highlighted

@purpleorchid 

 

Most probably that's literally what the message says - in one of your files there is the value which is expected as Date, but can't be converted into the date.

@Sergei Baklan I double and triple checked all data before I did the query and the query refresh. All date columns were already set up as dates on the original worksheets, before I even created the query and when creating the query I made sure to set that column as a date as well, so there was nothing that needed to be 'converted' to a date, as they already were dates.

@purpleorchid 

 

Could you provide the sample keeping only column(s) with dates?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies