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 edhans
just as edhans is saying, the xlsx-file is probably stored in a bad way. Most of this issues are solved by opening the file one time in Excel and make a save/save as.
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