Sorry we just realized that your message left unanswered. I assume you mean Azure Cloud Service project. If Azure Cloud Service projects packaging is enabled, the whole solution including unit tests is still going to be built and AppVeyor should detect and run unit tests at test phase, or test script if you selected test_script mode.
I am still not sure I understood your question correctly. if not, please elaborate.