I removed a table column and now I can't get it back

[Kimber]

In an effort to make my data set smaller, I transformed the data in the query editor to include only certain columns. Later, I realized that I need one of the columns I removed, School Level, but it's not included in the list of columns I can choose from. The column exists in the source database, but even after refreshing the data, I can't get School Level back into my model. Is there somewhere else I should look to find where it's being removed? 

Here's an image showing it exists in the database:

[Thaumaturgist · Accepted solution]

You'll need to go back through the "Applied Steps". Click the gray "x" to the left of "Removed Other Columns" in your screenshot to get back all of the columns you removed. Remove columns again, but this time do not remove "School Level".

Hoped this helped 🙂

[samratpbi]

Hi, at last step your column already removed. Assuming your report data is up to date, please select the previous step before "Remove Other Columns" step i.e. Navigation step. You should be able to see that column. Also you may go to Advance query and update it accordingly to keep the desired column.

Hope this helps to resolve your provlem. if it does, please mark it as solution, thanks!