Forum Discussion
MIssing last column in Power Query
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 Pradip,
Unfortunately I can't share the files as the information is too confidential and extensive to try and remove / replace. :-(
However, I have just noted that by deleting a random column in the excel file received before importing with power query has in sort resolved the issue as the last column is now visible!?
Obviously this is not ideal but can you think of any reason why this would be?
Thanks,
Gaz
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.
