Forum Discussion
Solved
Source Date Data Showing as Null in Power Query in Error
Problem: Valid dates from the source show up as null in Power Query at the very beginning of the query. Situation: I'm working on a project that pulls in data from an Excel (.xlsx) source file vi...
nerd_in_NE - there are issues with XLS files. One example is here but I've seen two others in recent months. Power Query cannot change the files - it is query only - and cannot reliably get info if the formatting is off in the file in some way. You have two choices:
- Save as CSV
- Save as a true XLSX file. Unfortunately, many ERP exports do not follow the MS file spec, so while it can look like an Excel file to Excel, it may not to other tools like Power Query because the vendor has not adhered to the rules of an XLSX file structure.
Hello nerd_in_NE
if you have a flat file (meaning only one sheet with one table in it) store the file as .csv-file then you are on the save side. Otherwise storing as xlsx-file should also always work out. (At least I never encountered something different)
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
