24 Years X-ray observations trace the mystery behind one of the brightest X-ray emitters in nearby galaxies