Fate of the Hero of Daggerfall

[MidbossVyers]

OK, first of all, know that I have Daggerfall but never completed it (wow, diseases in this game are deadly). However, in canon, what happens to the Hero of Daggerfall in the end? I've heard in some circles that the Hero dies at the end, but it appears much more vague than what happens to the Hero at the end of the other main games (Arena, Morrowind, Oblivion, Skyrim). Is this true? The main reason that I ask is because I've heard that Battlespire was originally meant to be an expansion to Daggerfall, so for RP's sake, would it be canon to have my Battlespire character based off of my Daggerfall character (obviously, this would make no sense if the Hero of Daggerfall dies in canon)?