Try the reset: push and hold the button straight upward and it will attempt to reset it. Do not let go until it all stops.

BMW Sunroof Initialization Procedure Panoramic Roof - YouTube

Other than that, the sunroof cassette can be a problem. They tried to fix the wind deflector in front getting stuck up by replacing a piece in the cassette but eventually replaced the whole cassette after I brought it in 3 times for the same issue.

__________________
'08 X5 3.0si - Alpine White / Saddle Brown interior
Specs: Sport Pkg, Premium Pkg, Tech Pkg, Comfort Access, Aero Kit, Style 433 staggered 20s on Conti DWS
Mods: Carbon 35 tint, LED angel eyes, GP Thunder 7500k fogs, H&R 20mm/25mm spacers, clear reflectors, gunsmoke-tinted taillights
Coded: Digital speedo, windows/sunroof/tailgate close via keyfob

X5 pics at Flickr