Wales could attract a £47 billion investment opportunity from renewables by 2035.