Fastest way to get a #msbi VM with #sharepoint 2013 & #PowerView Multidimensional? use online MS sales demo VMs
July 21, 2013 Leave a comment
Do you need a clean Sharepoint 2013 #msbi VM with PowerView multidimensional for demos/testing purposes? Don’t want to –or can’t- build one from scratch? and have you access to Microsoft partner resources?
Online pre-prepared #msbi vms&demos at http://fs.mssalesdemos.com/
Well, be sure to check the MS partner site http://fs.mssalesdemos.com/ for demo VMs. You’ll find at least two fully loaded VMs for #msbi with SharePoint 2013 and several prepared demo content & resources (powerview, powerpivot, excel).
These VMs work extremely well for demoing or testing purposes, they start in minutes and you connect using remote desktop. Performance is very acceptable. And you can save them for later use! :)
Download and install SQL 2012 SP1 CU4 for SSAS multidimensional support in SharePoint PowerView
I started up an instance of the “SQL Server 2012 BI Demo – Breakthrough Insight (March 2013)” VM. Already has SQL 2012 SP1.
Wait until the VM starts, connect using the rdp link:
and just download the hotfix inside the VM (should be very fast, 770MB took only a few minutes in my case).
Apply the SQL 2012 SP1 CU4 (I updated all instances just in case, took a bit longer). (ps-be sure to stop the World Wide Web Publishing Service service to avoid a restart and closed all Man. Studio and similar apps,
restart the www service after CU4 finished)
And you’re done!
Create a “Semantic Model connection for PowerView” data source for your SSAS cubes
Now, just create a new data source in Sharepoint (ex: http://intranet.contoso.com/Shared%20Documents/) and open it to start PowerView . You even got some multidimensional models installed (ex: contoso retail).
Click the created data source and PowerView should open connected to the Contoso Retail cube:
& Save the demo VM for later use on mssalesdemos
And for the better part :), you can then save the VM for later use (just don’t trust it will be there forever… they sometimes expire and disappear without warning…).
For this use the “Stop and Save” option (prepare to wait between 5-10 minutes while the VM is saved).
The new VM should then appear in your catalog. You can come back later and start from were you left off:
btw- if you want to check other demo resources in the VM: