PowerQuery: Get data from Excel - missing last column in navigation; gets visible after modification

[MichielJansen]

Hello all,

I have an issue when loading an Excel file into PowerQuery: we receive a sales forecast file from an external partner via mail, that contains 18 columns of data. When I save the attachment and directly load this .xlsx file in PowerQuery - it only recognizes 17 columns - the 18th column is not showing (which is a column I actually need). If I open the attachment first and save it or 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 (18th) column is recognized.

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

Curious to see if more people experienced this as well and if it is a strange bug that can be resolved.

Regards,

Michiel

[v-chuncz-msft]

@MichielJansen 

Take a look at link below and create a support ticket for assistance if necessary.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-excel-workbook-files#workbooks-with-r...