Yes, It is not a drain that is clogged but a poor design of the sunroof drains that leaks. I took my entire headliner apart two months ago and fixed them. Here is an illustration of what is happening (this a an image as if you were standing on the passenger side of the car looking at the pillar between the windshield and door. The hose runs down the pillar and drains at the lower hinge of the door).
Basically, Audi applied some glue at this seal point but it has worn away. I bought some Gorilla Glue and glued the crap put of it. I let it dry overnight and tested it. Worked like a charm but the headliner was a pain to remove and put back. Search the forums for a DIY.
Good luck!