Column of the table wasn't found

[Aazza]

I'm having some issues connecting a column of my table in Power Query.

I have made sure that that all the sources and sample files are connected. I have tried refreshing but still unable to find the column in my table. Have had no issues connecting the previous column.

Any tips on how to resolve this issue would be greatly appreciated.

[Aazza]

For more details on the issue here is the advanced editor of the Additional Information query. When viewing the sample file that it is linked to I can see the Salary and previous columns with the rest of the table.

[Vijay_A_Verma · Accepted solution]

See if this is being caused due to case sensitivity i.e. whether your column name is "salary" not "Salary". Also check if column name in table is having some whitespace character at the end or beginning. 

[Aazza]

Hi @Vijay_A_Verma 

Just checked and it turns out the Column's text was aligned centrally rather than to the left so there was spaces either side which explains why i wasn't able to find the Column 'Salary'