Closing the window on single leptoquark solutions to the B-physics anomalies