Installing PivotViewer Extension for Reporting Services including the sample app

First of all the PivotViewer Extension for Reporting Services is ready for download here. The installation is described in an excellent installation guide that is included in the package, a must read for anyone who wants to start with the PivotViewer Extension for Reporting Services.

What do you have to do to install it into your SharePoint machine, in my case i have a single box. My sharepoint is at http://powerpivotand have integrated SSRS with the following service url http://powerpivot/ReportServer_SQL  my SQL Server is installed at PowerPivotpowerpivot (machine nameinstancename).

The following steps you need to do:

  • Open an command prompt with Administrator access and run:
    BICollectionDBProvision.exe -sPowerPivotpowerpivot -op
    This will create a database on a local database in my case “PowerPivotpowerpivot”
  • Open the SharePoint 2010 Management Shell command prompt with Admin access:
    .installBIPivot.ps1 “-whttp://powerpivot” -oi -y
    This will install SharePoint specific features for the Pivotviewer, like the Crawler and viewer control on my SharePoint machine “http://powerpivo”. This syntax is different than from the intallation guide, i had to run it with . in front of it because my location wasn’t a certified location.

This is all you have to do. Remember this is not a replacement for the installation guide just gives you what i did.

Next up is installing the Demo app. Again open the command prompt with admin privilages and run

BICollectionSampleBuilder -rhttp://powerpivot/ReportServer_SQL -whttp://PowerPivot -gSampleGallery -dSampleDocuments

this installs the app files on your SharePoint.

Now all you have to do is create a page in sharepoint and add a “PivotViewer BI Report Crawler” webpart to your page. Select the Accountmanagers invetory and start crawling, the report is now rendererd for all options in the pivot viewer.

Finaly create a second page and add the “PivotViewer BI Data Browser” webpart to the new page and in the properties set the Inventory to “Accountmanagers”. Your Pivotviewer app will now be working:

Again make sure you read the manual, i had trouble as well because i didn’t read it as well as i should !

Check out this video about installation as well: http://petcu40.blogspot.com/2010/07/pivotviewer-extension-for-reporting.html

  • Hi Kasper,

    Can you help me on installation of the sample. I have installed everything as per the instruction given in the doc. When I Crawl AccountManager inventory, it just flashes and stops but does not add any records to the database.

    I can open the Excel and see without any issue but report cannot be opened, not sure whether it is normal, this is what I get when click on the report in the Sample Gallery;

    ——————————————————————————–

    An error has occurred during report processing. (rsProcessingAborted) Get Online Help
    Cannot create a connection to data source ‘AccountManagers’. (rsErrorOpeningConnection) Get Online Help
    A connection cannot be made. Ensure that the server is running.
    The requested name is valid, but no data of the requested type was found

    Appreciate if you can help on this to get it worked.

    Thanks

  • Andrew Sadler

    Hi Kasper,

    Have you had any joy setting this up for SQL 2012 RC0 yet?

    If so what are the neccessary tricks – I manage to install the sample but I get an error when i try to crawl the Inventory. Error is Unsupported data format : application/vnd.ms-excel.12

    Any help would be greatly appreciated

    Thanks

    Andrew

  • Peter

    Dear all,

    I have the same issue and error message. I’ve SQL 2012 with Windows 2012 and SharePoint 2012. I tried to resolve the issue by installed ADOMD.NET v.11 but it doesn’t help.

    Error is Unsupported data format : application/vnd.ms-excel.12

    Do you have any advises?

  • sarah

    @Andrew Sadler
    Hi Andrew, Hi Kasper,

    Have either of you managed to get around the ‘Error is unsupported data format’ issue?

    I’d really appreciate some help! Thank you.

    • Kasper de Jonge

      unfortunately I don’t think this is going to be fixed any time soon.