Schema update post addition/deletion in data source

I want my semantic data model to be udpated with column updates, is there a way to automate this? ( I do not want to do it manually) 

Power Query is extremely sensitive to that.  It will react with "key not found"  errors etc, especially for removals.  You would have to implement a complete CI/CD solution to make this even remotely work, but don't expect it to be a smooth experience at all.