The story
The figurative sense comes by metaphor from the literal sense: the notion that a chain is only as strong as its weakest link. (See historical details there.)
Etymology from Wiktionary, CC BY-SA 4.0.
weakest link
Today it means: The part of a system that is most likely to cause problems or fail. Full definition →