Use missingfield.ignore on source data

 Hi All,

I have a data source from excel where I have removed numerous columns.  When I go to import the updated excel file with less columns I get the "Missing Fields Error" and am unable to import the data.  I do not want any of those columns, and rebuilding the whole import just for a few missing columns, at this point, would be a massive pain.  I read about the ability to use missingfield.ignore on tables...however, I'm unsure how to use it upon importing the data source.  Ie, is there a way to utilize it on:

= Source{[Item="case_all_sentiment",Kind="Sheet"]}[Data]

For example, = Source{[Item="case_all_sentiment",Kind="Sheet"]}[Data],MissingField.Ignore

(NOTE: I know this does not work).