I have the same problem with my Nexus 7 (Google tablet) and Windows 8.1, while it gets detected (and auto-intall of drivers) on Windows 8.

Strange thing is that I could upload .apk-files with Android SDK / Unity and the "data connection" over USB works. I just can't figure out the normal "SD-card" like interface.