Since windows doesn't see it, I'd guess power or ground have been interrupted, likely by broken solder joints or snapped traces.
Alternately both data lines or all four connections could be broken.
If I were repairing such damage for my own use, I might use a short piece of usb cable and solder the wires to the next nearest component of each trace, stabilizing/protecting the repair with epoxy once electrical function was confirmed. But that's me and my bodges, you might be able to get away with re-soldering connections and/or bridging the breaks with fin wire. Such tiny fiddly stuff!