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 - I was experiencing the same problem - i.e. the last column of the file was not being loaded, for me this problem was solved when amending the (defaulted) Row Delimiter value of (\r, \n or \r \n) to Line feed (\n)
Hope this helps; kr, Dilip