Forum Discussion

UK06B1's avatar
UK06B1
Icon for Helper II rankHelper II
3 years ago

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...
Need Help
Waldo35's avatar
Waldo35
Icon for Helper I rankHelper I
3 years ago

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