It’s not that you heard from God wrong, “it” didn’t work out because you were trying to do something permanent with temporary people or you were trying to do something permanent in a place (career-wise, ministry-wise, business-wise, locationally, etc.) that you were only called to dwell in temporarily and that’s not the place where you are called to do that permanent thing. Purpose and provision are often connected to a place. Ask God to send you the covenant people to whom you are called and to show you the places to where you are called. Then try “it” again with God when He leads you to do so.