How to show a Power View report at the SharePoint page (Silverlight Web Part)

  • Synopsis

    This guide will show you how show a Power View report at the SharePoint 2013 page using Silverlight Web Part.
  • Applicable to

    All PlexHosted accounts subscribed to SharePoint 2013 Business Intelligence plan.
  • Prerequisite

    • a PlexHosted SharePoint 2013 Business Intelligence account
    • a PlexHosted SharePoint 2013 Business Intelligence site
  • How to

    1. Login to the SharePoint 2013 site as an administrator.
    2. Navigate to the page on which you want to show your Power View report or create a new page.
    3. If you have created new page, go to the Insert tab and click on Web Part. If want to add a Power View Report to the existing page, first check out this page, and click the Edit button on the ribbon.
    4. From the Media and Content category choose Silverlight Web Part and click Add.
    5. You will be prompted to enter the URL path for the Silverlight application. (That setting and address is also available when editing web part settings in the Application section when you click on the ‘Configure…’ button.) Enter the URL and click OK. The URL path to the Silverlight application is the following:
      http://yourcompanydomain.com/_layouts/ReportServer/ClientBin/Microsoft.Reporting.AdHoc.Shell.Bootstrapper.xap
    6. SharePoint will load the Silverlight component. If it fails – no worries, there are several settings that need to be entered to make it work. Click on "Edit Web Part" from the Web Part drop down menu.
    7. Specify the title, height and width for the web part in the Appearance section.
    8. Under Other Settings click on the button with the ellipsis (...) near the Custom Initialization Parameters box.
    9. In the text editor enter the initialization parameters for your report. The initialization parameters have the following format:
      ItemPath=http://yourcompanydomain.com/yoursite/YourReport.rdlx,ReportServerUri=http://yourcompanydomain.com/_vti_bin/report
      We have used the following parameters in our web part:
      ItemPath=http://yourcompanydomain.com/PowerPivot%2520Gallery%2FPower%2520View%2520Report.rdlx,ReportServerUri=http://yourcompanydomain.com/_vti_bin/reportserver/,ViewMode=Presentation,ServerTraceLevel=1,AuthenticationMode=Windows,ReportSection=ReportSection


      Additionally, you can find these parameters if you open the "View Source" of the Power View editor in browser. There you can see the "InitParams" and the necessary parameters after it. (If you have used this method, make sure that you have replaced the encoded characters like %20 or %2F to the appropriate symbols – space, / etc.)
    10. Click Apply to make sure that your initialization parameters work and you can see the report.
    11. If everything works, click OK.
    12. Click on Save button either from Format Text tab or from the ribbon to save the changes on the page.
    13. Go to the Publish tab and click on Publish button.
    14. A publish window will pop up where you can add your comments. Click Continue.
    15. Now you can see the published page with your Power View report.

    If you need further assistance, please do not hesitate to contact us.

  • Keywords

    SharePoint 2013, Enterprise, Business Intelligence, page, report, Power View, Silverlight Web Part, Report, show
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How to create a Power View report (SharePoint 2013 Business Intelligence site)

Synopsis This guide will show you how to create a Power View report at the SharePoint 2013...

How to create a Power View Map (SharePoint 2013 Business Intelligence site)

Synopsis This guide will show you how to create a Power View Map at the SharePoint 2013...

How to change the view in the PowerPivot Gallery (SharePoint 2013 Business Intelligence site)

Synopsis This guide will show you how to change the view in the PowerPivot Gallery at the...