Its the cable. A Galaxy S7 can detect the type of cable and will only charge on lower quality cables, not allowing file transfers.
Try a different (better) usb cable.
Is there a way to make this the first post in the thread?
Thanks Another Mike, as soon as a pulled out an old charger cable it worked fine after failing trying everything else