Forum Discussion
Solved
MIssing last column in Power Query
Hi All, I have a query setup which imports new data from various excel sheets each week. However this morning and for some unknown reason my query has stopped recognising or importing the last c...
Hi, just to add that as a workaround I have found that my adding an additional 'unwanted' column at the end of my reports that I am importing this then in part resolves the problem as that column now being the last is being ignored and the one I need is not!
Bizarre!
Hi, just to add that as a workaround I have found that my adding an additional 'unwanted' column at the end of my reports that I am importing this then in part resolves the problem as that column now being the last is being ignored and the one I need is not!
Bizarre!
This thread is a few years old, but I just had this problem. In my case the source is an .xls file. I opeded the source and saved as .xlsx, then used the new file as the source and no longer had the issue.