Not all dreams are possible or realistic. When this happens you have to bade them farewell.
This isn't failure, but it's a sign of maturity and learning on your part.
All you need to do is rethink what you wanted to do, in the first place,and see what you can change.
Then that is called determination and that, will lead to you having success.