Rain water leaks from overhead console (No sunroof)

A simple test is to feel around the carpet in that footwell. See how far up under the dash the carpet is wet. Does it only happen after rain? Do you have a sun roof fitted?
If the carpet is only wet low down on the floor the most likely reason is either a perished or damaged door seal rubber, a faulty sun roof seal or the drain channels for the sun roof are clogged up. Check the footwell in the back as water always flows and settles at the lowest point in the vehicle.
If it is high up and nearest the middle of the dash you issue could be the heater matrix under the dash but as it seems to be only on one side this might not be the issue.
Door seals are a simple case of pull the old one off and push the new one on and they don't cost silly money to buy. Heater matrix issues, unfortunately, usually involve taking the whole dashboard out to get to it.
Hope this helps.

is the water leak allowing the water to wick up into the headliner or is the headliner getting wet without water coming past the weather stripping around the door?

If it is wicking then fix the weather stripping.
If the water is getting headliner wet with out passing the weather stripping then you have a leaking sun roof.

You can the door seal by sitting in the car while you have some spray water (garden hose) gentle at the frontal and upper door seal.
If not leak there inspect seal of sun roof and real seal with correct type of sealant.

I had the same problem with my jeep. If you aren't positive that it is your sun roof check to make sure that your doors are shutting completely. One way to check is by pouring water along the crack where your door meets the body of your car. My sun roof as well as my drivers side door had a leak in them and instead of getting the sun roof fixed I had sealant put around the rim of the window and I haven't had any problems since.

clean out the drain tubes for the sun roof

they have drain lines at sunroof, need to take air hose and blow tip and clear out debris, also check seal at front windshield.

More likely is a leak at the windshield seal at the top of the windshield. The water on the floor could also be coming from around the windshield, water leaks travel anywhere they find a path. On a dry day, take a garden hose and with very little water flow, apply the water to the top of the windshield for a while. Check for water on the floor. The water that's getting into your electronic console is probably happening at speed.

Review the Service Manual Section-23-Body-ewj23S (page 8 and next).

I really hope help you with this; remember rated this help. Good luck.

lift rubber edges and apply clear silicon sealant under edges let cure hose with water to test, if leak then seal edges of glass with eurothane sealant, not silicon will rot in sun within year

I also have a sunroof that leaks on a 2002 Yukon. It is a factory sunroof with a cracked seal. Where can I get a new seal?

If you open the sunroof, look towards the rear corners and you will see 2 openings that are the drains. If the drain openings are clogged, you will get water into the car from the sunroof.