In the sentence, "Were you at his house yesterday?" at is used to indicate location.
Similarly, "Were you at home yesterday?" uses "at" to indicate location.
However, the sentence "Were you home yesterday?" is also correct, but does not use the "at" preposition.
We cannot ommit "at" from the first sentence the same way.