Forum Discussion
UK06B1
3 years agoHelper II
Columns missing from data file in power query
Hello I have an issue when i link power query to a data set it only brings thourgh up to column 7. But when i open the data file in excel there is data in column 8. Is there a way in the ad...
Waldo35
3 years agoHelper I
did u make the columns into a table, and what did you select in the navigator. If possible make it a table in the excel and then select the table in the navigator, maybe that leads to better results. But it should work either way so something weird is going on. Also try restarting / making a new excel and copying the data.
sheet version
table version