Is Once Upon a Time a prepositional phrase?

No, "Once Upon a Time" is not a prepositional phrase. It is a noun phrase functioning as an adverbial phrase to indicate the time at which a story is set to begin. Prepositional phrases typically consist of a preposition followed by a noun or pronoun, such as "in the morning" or "under the table."