Star Trek: Deep Space Nine (1993)

S06E26 Tears of the Prophets

Stardate: Unknown. Sisko receives the daunting assignment to lead an offensive against the Cardassian homeworld. However, he is suddenly visited by the Prophets in a vision, cautioning him about a looming disaster that awaits if he decides to abandon the station.