You remove a conditional column in Query Editor from your data set. However, now you see that the Close and Load To button is grayed out. Why is this?

Select an answer:

The query was already loaded to the data model, as you wanted, and not to a worksheet.

You have to select Save before you can use Close and Load To for your change.

The query was already loaded to a worksheet, which is where you set it up to load.

Query Editor is not the right place to make the change that you made.