Star Trek: Deep Space Nine S06 E26 Tears of the Prophets

"At the edge of the Final Frontier, the Universe's greatest mystery is about to unfold."

Stardate: Unknown. 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.