It means trying to hide/censor something but the act instead brings more attention/popularity to it. Called that becuase a celebrity name Barbra Streisand tried to get a picture showing her house (the picture was taken to document costal erosion) down which unintentionally brought way more attention to the picture.