If, as you suggest, the "he" is Messiah, then this would mean that it is Messiah who makes desolate...that He is the abomination of desolation.
You sure of who "he" is?
At this point, Messiah is cut off.
This is an aspect of Christ's first coming. The Jews expected national salvation, Christ brought spiritual salvation.
Christ's return is expected by most at the end of the tribulation, as we read in Revelation.
This is why rapture believers see a significance in our be gathered to Him in the clouds. Again, I am not dogmatic on this teaching, but I do lean more towards it happening than not.
When He returns, He will physically return to the earth (Zech. 14).
The tribulation is the Day of the Lord. It is a time of judgement. It is the final week which applies to Israel.
The passages found in the gospels refer to this time.
One will be left, one will be taken (in judgement).
We know the Day of the Lord will come as a thief (those it befalls will not see it coming).
We know it is coming, and those who are His do not fear this day, whereby Paul says we can comfort one another. Not be in fear of death nor the coming wrath of God.
But I have never heard one try to make the "he" of 9:27 Messiah. What is your "biblical foundation" for this.
Not trying to be argumentative, just curious as to how you arrived at this interpretation of this verse?
I'm going to answer these questions - as many as I have time for tonight, at least - in a new thread, "Christ in Daniel 9". This thread has drifted away from the original post.