Category Archives: SharePoint

Sharepoint BI Demo Machine Full Download

Shortcut your Sharepoint Business Performance experience with this pre-packaged virtual machine available for partners and customers, pre installed with industry specific Sharepoint dashboards like Education, Energy and Communications.

contoso dashboard

If you get along to you will find some online demo’s but this one is a full downloadable virtual machine – ok it is only Sharepoint 2010 on SQL 2012, it has a cool footer but for the tragic Windows Phone 7,  and it is only a Generation 1 VHD Hyper V machine.    If you are a Virtual Machine Jedi with an extremely high Midi-chlorian count, you may have a chance of converting the image to run on virtual machine clients like VMWare Client and Virtual Box.  I had best luck using Hyper V host on Windows 8.1.  Download is approximately 20Gb, so if you are having problems, try a Download Manager.

Here is the actual link to the Virtual Machine –  Instructions for how to mount the Virtual machine under Hyper V are included in the page comments including administrator password, domain and ip addresses.  If you are running Hyper-V in Windows 8.1 or Windows Server 2012 R2, you will notice the instructions are written for the older version of Hyper-V – the terminology has changed slightly.   Instead of importing the Virtual Machine, you will find it easier to create a Generation 1 Virtual Machine, assign the internal network that you created using the Virtual Switch Manager, then add the add virtual hard disk from the uncompressed image files. Once the virtual machine starts, you are almost there.  Login with these initial login details, the following the remaining steps in the setup procedure :

User: administrator

Password: pass@word1


Link to Free Download Manager below, which I am no way affiliated with, it just solved my headaches with Akamai download manager and Internet Explorer.   This worked well to download this particular file but had no luck with resuming interrupted MSDN downloads.

PowerPivot for Sharepoint – Locating Analysis Services on a Different Server

PowerPivot for Sharepoint 2013 supports a variety of different installation architectures – one of which allows you to run the PowerPivot Analysis Services instance on a server other than your Sharepoint 2013 server.   You still need to install PowerPivot software on your Sharepoint server, however only the spPowerpivot.msi package (or on all Sharepoint servers if you have a multi node Sharepoint farm) – this can be found on your SQL Server install media or located on the SQL 2012 feature pack   Make sure the same version of msPowerPivot.msi is used on all servers in farm.

Make sure you specify the Excel Services Data Model settings in the configuration of your Excel Services Service Application – this is the instance name of your PowerPivot instance e.g. HOSTNAME\POWERPIVOT.

For Kerberos configuration you will need to get the Port number of your POWERPIVOT instance (as well as the port number of the browser service), create your MSOLAPsvc.3 and MSOLAPDISCO.v3 SPNs then add these to your constrained delegation configuration.

Finally, you need to run the PowerPivot configuration tool to complete your installation – because you installed msPowerPivot.msi on the Sharepoint server, you can run the PowerPivot configuration tool and finish the PowerPivot integration.

Screen Shot 2014-01-19 at 7.08.40 am

Self Service BI Navigation Menu in Sharepoint

Less than 10 easy steps to create a Sharepoint Self Service Business Intelligence Navigation menu like this…


A link to PowerPivot will open your PowerPivot Site, Dashboard Designer will open your Performance Point Dashboard Designer, and the third item in the menu is for the Report Builder 3.0 click once application.

First, open your site, go to Site Actions > Site Settings > then Under Look and Feel select Navigation.


Under Global Navigation select these settings…


Under Navigation and Sorting, select Global Navigation and select Add Heading…

Sharepoint Navigation and Sorting

Give the Heading a name…Self Service…


Now select the Self Service Heading and we are going to add 3 links for PowerPivot, Performance Point Dashboard Designer and Report Builder.  The PowerPivot link will already be there if you have created a PowerPivot site.  Simply select PowerPivot under Global Navigation and select Move Up or Move Down to position this item directly underneath the Self Service Heading.


To Add a Dashboard Designer link, select Self Service then Select Add Link…


Name the link “Dashboard Designer” and set the URL to be something like this (may vary for your Sharepoint site) e.g. if your BI site is referenced as /sites/BI/yoursite then try…



Now add another link and name the link “Report Builder 3.0″…with the URL set to be something like this (may vary for your Sharepoint site) e.g. try this for start…



Now click OK on your Navigation screen MOST IMPORTANTLY !….Clicking OK at your Navigation screen will save all the changes you just made to the Navigation menu – otherwise all your good work will be lost! Scroll down until you see the heading Show and Hide ribbon – the OK button you need is below here!


Now test each link in your new Global Navigation Self Service menu to make sure each link launches successfully…


Thats it – a Self Service BI menu in Sharepoint in under 10 easy steps !

Location of RSReportServer.config for SSRS Web Service URL Sharepoint Integrated

You want to find the rsReportServer.config file for your SQL Server Reporting Services 2012 Installation.

Basically….for a Sharepoint Integrated Mode install of Reporting Services look in …

<Drive Letter>:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\WebServices\Reporting

Typically the location of your reportserver url is going to look something like this if your sharepoint web url is …

<a href=""></a>

and for a Native Mode Reporting Services installation look in …

<Drive Letter>:\Program Files\Microsoft SQL Server\MSRS1111.MSSQLSERVER\Reporting Services\ReportServer

Forecasting and Budgeting with the Microsoft Business Intelligence stack

There are a myriad of point and shoot forecasting and planning tools out there however the Microsoft Business Intelligence stack has capabilities in this area too.   You may already have some Microsoft infrastructure so its worth looking what you can do in Sharepoint, Excel and the other Microsoft BI tools before you go and buy yet another reporting tool.

Check it this whitepaper here that discusses some scenarios in the planning and budgeting process and some how some typical architectures might be assembled together to meet each scenario…

Can I run a PowerPivot 2012 (v2) Excel 2010 document to Sharpoint 2013

You can run a PowerPivot 2012 (v2) Excel 2010 document up on Sharepoint 2013 server.  The following read outlines a the pros and cons. Note Excel 2013 Powerpivot documents support Interactive refresh within the open workbook however PowerPivot v2 for Excel 2010 only supports Unattended Refresh.   At this stage I havn’t any luck getting data refresh to work with Excel 2012 v2 Powerpivot documents and a bug is mentioned here PowerPivot  v1 does not support interactive nor unattended data refresh so you are best converting these.



Reporting Services 2012 SP1 Addin For Sharepoint 2013

Those integrating Reporting Services with Sharepoint 2013, note you need the 2012 SP1 add-in for this to be successful.  Otherwise you may find your Sharepoint Powershell commands Install-SPRSService and Install-SPRSServiceProxyCommands won’t work.

Happy Days !