Question

Omar Sultan on Fri, 10 Aug 2012 11:25:12


I am currently trying to enable Power View on a SharePoint site without having to install Power Pivot, Is this doable or not? The aim is to allow users to create power view reports by connecting to a Tabular SSAS Cube.

The following components are installed on the Server:

  • SharePoint 2010 SP1
  • SQL Server Reporting Services Add On - 2012
  • SQL Server Reporting Services - SharePoint Integrated Mode
  • Tabular Instance (Hosted on another server on the same domain)

The following services and features are activated on SharePoint

  • Reporting Services Service Application

The Following features are activated on the SharePoint site

  • Power View Integration Features
  • Report Server Integration Features

I do not which to install a new instance of Power Pivot for SharePoint unless it is necessary for me to get Power View to work with a Tabular Mode Instance.

Thanks.


Sponsored



Replies

luisefigueroa on Fri, 10 Aug 2012 14:08:53


In my experience you have to install PowerPivot for SharePoint in order to make available the BI semantic model conection in SharePoint. You will need this connection type in order to connect to a tabular model as a PowerView source.

It is not clear on the documentation online wheather PowerPivot for SharePoint is a requirment for PowerView but It seems to me that it corrently is.

Luis

Samrat Bhatnagar on Mon, 26 Nov 2012 21:18:26


Hi Omar,

For creating PowerView reports PowerPivot for SharePoint installation is NOT a requirement. PowerView is a feature of SSRS 2012 addin for SharePoint 2010 Enterprise Edition.

If you want to create PowerView reports on top of Tabular model follow the steps given below:

1. Enable SSRS content types for a SharePoint Document Library( In case of BI Center template the doc lib is Documents). This would enable Report Data Source which allows us to create Shared Data Source.

2. In the same library now create a new Report Data Source, for the Data Source Type box, select "Microsoft BI Semantic Model for Power View".

3. Connection String for tabular model would be of the form:

Data Source=AnalysisServicesInstance; Initial Catalog=Tabular Model Name

4. Now click on the context menu for the shared data source created in point 3 and select 'Create Power View Report".

-Samrat

sai sudeep on Mon, 10 Jun 2013 11:16:52


Hi

Would you specify the step by steps how to configure the steps  1 to 4 as had given

 currently i am done with installation

•SharePoint 2010 SP1

•SQL Server Reporting Services Add On - 2012

•SQL Server Reporting Services - SharePoint Integrated Mode

•Tabular Instance (Hosted on another server on the same domain)

please let me know  next steps and how to proceed with rest of configuration in detail

Thanks

Ram