1

I am new to Microsoft BI and I am wondering if you need SSRS installed in order to deploy a PowerView report to SharePoint. My datasources will be Excel files.

I know my company has a SharePoint (don't know yet which version). I don't think SSRS is installed, can I still deploy a PowerView report on the SharePoint? Or is SSRS needed for this requirement? Datasource will be just excel files.

Improve this question
2
  • I am afraid SSRS is needed: 'Power View, a feature of SQL Server 2014 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition.' Source msdn.microsoft.com/en-us/library/… Commented Apr 13, 2015 at 12:02
  • Can someone confirm? Are there workarounds? Or is SSRS really required.. Commented Apr 13, 2015 at 12:10

1 Answer 1

Reset to default
0

No, you need SSRS in SharePoint mode in order to use Power View reports. You will also need to have the Reporting Services Add-In for SharePoint and PowerPivot for SharePoint installed and configured. Your SharePoint instance will need to be 2010+, depending on your version of SQL and Excel.

When deployed in a SharePoint BI Centre, Power View utilises components of the SSRS installation for the report, and uses the PowerPivot server (essentially an SSAS Tabular instance) to store and process the data model.

If you think about it, it makes sense, since a Power View .RDLX file is essentially a zip file containing an SSRS report and some other stuff. Dan English wrote a good article exploring it.

MSDN has a good deployment checklist that I've used myself in the past.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.