Star Trek: Deep Space Nine Season 6 Episode 26

When Sisko is picked to head up an attack on the Cardassian homeworld, the Prophets appear to him in a vision, warning him of impending doom if he leaves the station.