I am a novice using Hyper-V to create SQL Server BI environments; a VM for SSAS tabular, one for SharePoint BI etc. I was wondering if there was a way or method to have my host machine connect to one of my VM's via a virtual network, mainly for the purpose of pointing an Excel instance or PowerPivot within my host machine at a db in one of the VM's. I have done considerable searching on this topic but admittedly am not clear about it, networking is NOT a strong suit. I currently have an external switch /network adapter so that VM can use my host's internet connection, but I think if this is possible, its much more integrated of an config.

My question... is this possible? If so can someone point me in the right direction?

Vinnie