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?
@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.