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 Gazsim44 ,
It will be difficult to assume the cause of missing column but according to my knowledge, the Power Query is highly case sensitive. If the spelling or the case is different from the one in Power Query then it may not import it. In such cases the Power Query gives error.
Another reason that i can think of could be data type mismatch.
Is it possible for you to share the file?
Regards,
Pradip Microsoft Certified Trainer
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.
