The description for Sweet Dreams is "Sleep in a bed to change your respawn point"

But, you don't actually have to sleep in the bed to achieve the advancement. All you have to do is lay in the bed, not go to sleep.