His plan to become a millionaire overnight is just a pipe dream.

Su plan de hacerse millonario de la noche a la mañana es solo una quimera.

Getting a promotion without working hard is a pipe dream.

Conseguir un ascenso sin trabajar duro es una quimera.