Musnad Ahmad Hadith 18066

A man came to the presence of the Messenger and said, "Pray to Allah for rain for the tribe of Mudar." The Prophet (peace be upon him) said, "You are very bold, should I pray for the people of Mudar?" He replied, "O Messenger of Allah! (peace be upon him) Allah has helped you, granted you, accepted your supplication, (your people are perishing, pray to Allah for them)." So the Prophet (peace be upon him) raised his hands and said, "O Allah! Quench us with abundant rain that fills the earth with water, let it be plentiful, not delayed, beneficial, not harmful." After this supplication, the Friday prayer had not yet taken place when the rain started. After some time, those people came to the Prophet (peace be upon him) complaining about the excess of rain and said that the houses had collapsed. Upon this, the Prophet (peace be upon him) raised his blessed hands and said, "O Allah! Let the rain fall around us, not upon us." So the clouds scattered to the right and left.