Controversial plans for a huge solar development, just 160 metres from a site described as the birthplace of Roman Britain, have been thrown out.