Get data from Excel - missing last column in navigation; gets visible after modification to original

[MichielJansen]

Hello all,

I have an issue when loading an Excel file into PowerQuery: we receive a sales forecast file from an external partner that contains 18 columns of data. When I try to load this .xlsx file PowerQuery only recognizes 17 columns - the 18th column is not showing (which is a column I actually need). If I make a small modification to the original Excel file (e.g. as simple as just adding a random number to a random cell in any of the worksheets, not even the one I need) - the last column is recognized 🤔.

Attached a print screen of the behaviour of both orginal file behaviour and after modification behaviour.

Did anyone experience this before and has a potential workaround (other than modifying and saving the file like I do today). I have a PowerAutomate solution running that saves the Outlook attachments automatically upon receipt and would like to avoid any manual intervention to the files. 

Thx a lot for your feedback!

Kind regards,

Michiel

[v-eachen-msft · Accepted solution]

Hi @MichielJansen ,

I cannot reproduce this issue on my side, here is a similar case for your reference.

https://community.powerbi.com/t5/Power-Query/MIssing-last-column-in-Power-Query/m-p/786933

You could also log an issue at

https://community.powerbi.com/t5/Issues/idb-p/Issues