When the evidence points somewhere I didn't want to go, I follow it anyway. My hopes don't get a vote in what's true, and I've made peace with that. Being honest about what the work actually shows is the whole reason I do this.
More people experience this than they realize.
You follow the evidence over your own hopes, treating honesty as the point of the work.
If this sounds familiar, the Library can help you find the bigger picture.