The only way to fix a non-working USB port is to replace the entire logic board. It would also cost a few hundred dollars or more and would have to be shipped to a service center.
Buying our new original USB-C DC power jack board connector is your best bet and will save you time and money!

Identifying Numbers:
APN: 923-01480,923-01444
PPN: 821-00861-03, 821-00861-A, 820-00484-02, 920-01598-02, 921-00601-04

Package:
1 x DC Power Jack Board for A1706 A1707 A1708

Compatible Models:
-Compatible with MacBook Pro 15" with Retina Display and Touch Bar Late 2016 A1707 (EMC 3072)
For MacBookPro13,3 Late 2016: MLH32LL/A , MLW72LL/A , MLH42LL/A , MLW82LL/A or BTO/CTO
-Compatible with MacBook Pro 15" with Retina Display and Touch Bar 2017 A1707 (EMC 3162)
For MacBookPro14,3 Mid 2017: MPTR2LL/A , MPTU2LL/A , MPTT2LL/A , MPTV2LL/A or BTO/CTO
-Compatible with MacBook Pro 13" with Retina Display and Touch Bar 2016 A1706 (EMC 3071)
For MacBookPro13,2 Late 2016: MLH12LL/A
-Compatible with MacBook Pro 13" with Retina Display and Touch Bar 2017 A1706 (EMC 3163)
For MacBookPro14,2 Mid 2017: MPXV2LL/A
-Both of the Model "Axxxx" and EMC "xxxx " Number are located beneath the lower case of the laptop, please double check it to determine the compatibility.

Reminder:
1、Please check the picture & the compatiblity before your purchase.
2、This requires professional installation, if you are not a professional, please do not try it lightly.