A controversial application to build a solar farm near Powick has been refused after major backlash from residents.