Skip to main content

How to Install SQL Server BI Features with SharePoint 2013

SQL Server 2012 Service Pack 1 (SP1) supports Microsoft SharePoint 2013 Excel Services usage of Excel workbooks which containing data models and Reporting Services Power View reports.

Excel Services in SharePoint 2013 includes data model functionality to enable interaction with a PowerPivot workbook in the browser.
You do not need to deploy the PowerPivot solutions  for SharePoint 2013 add-in into the farm. You only need to install an Analysis Services server in SharePoint mode and register the server within the Excel Services Data Model settings.

Deploying the PowerPivot for SharePoint 2013 add-in enables additional functionality and features in your SharePoint farm.
The additional features include PowerPivot Gallery, Schedule Data Refresh, and the PowerPivot Management Dashboard.

The basic steps to deploy the PowerPivot for SharePoint 2013 add-in are the following:

1. Verify Excel Services is configured to use an in SharePoint mode. For more information, see Manage Excel Services data model settings.(SharePoint Server 2013)

2. Run spPowerPivot.msi to install the PowerPivot for SharePoint 2013 Configuration tool, SharePoint solution files, and data providers.

3. Run the PowerPivot for SharePoint 2013 Configuration tool to deploy and configure the PowerPivot features in SharePoint.

For information on how to download spPowerPivot.msi, see Microsoft® SQL Server® 2012 SP1 PowerPivot® for Microsoft® SharePoint®(http://www.microsoft.com/en-us/download/details.aspx?id=35577).
Microsoft® SQL Server® 2012 Service Pack 1 (SP1) (http://www.microsoft.com/en-us/download/details.aspx?id=35575).

spPowerpivot.msi: A Windows Installer package available with the SQL Server 2012 SP1 Feature Pack. The installer enhances the PowerPivot for SharePoint experience with more features such as PowerPivot Gallery and Schedule Data Refresh. The .msi deploys Analysis Services client libraries, the PowerPivot for SharePoint 2013 Configuration tool, and copies PowerPivot for SharePoint 2013 installation files to SharePoint servers.
After you run the .msi, you need to run PowerPivot for SharePoint 2013 Configuration to deploy the solutions and configure the farm.

Install and Uninstall the PowerPivot for SharePoint2013

To install PowerPivot for SharePoint 2013 with the Graphical user interface, following steps:

1. Run SpPowerPivot.msi.
2. Click Next on the Welcome page.
3. Review and accept the license agreement, then click Next.
4. On the Feature Selection page, all of the features are selected by default.
5. Click Next.
6. Click Install to install to finish the installation.

To install PowerPivot for SharePoint 2013 with Command Line Installation
For a command-line installation, open a command prompt with elevated permissions, and then run the spPowerPivot.msi.
For example:

Msiexec.exe /i SpPowerPivot.msi.

To create an installation log, use the standard MsiExec logging switches.
The following example creates the log file “Install_Log.txt” using the “v” verbose logging switch.

Msiexec.exe /i SpPowerPivot.msi /L*v c:\test\Install_Log.txt

 The PowerPivot for SharePoint 2013 Configuration tool is not required on every SharePoint server, however it is recommended to install it on at least two servers so it is available when you need it. Therefore when you install the spPowerPivot.msi, you can use the command line and to install the data providers and not the PowerPivot for SharePoint 2013 Configuration tool. The following command line is an example of including specific components in the installation:

Msiexec /i spPowerPivot.msi AGREETOLICENSE="yes" ADDLOCAL=” SQL_OLAPDM,SQL_ADOMD,SQL_AMO,SQLAS_SP_Common”

Option
Description
Analysis_Server_SP_addin
PowerPivot Configuration
SQL_OLAPDM
MSOLAP
SQL_ADOMD
ADOMD.net provider
SQL_AMO
AMO provider
SQLAS_SP_Common
Analysis Services common components for SharePoint 2013

To install PowerPivot for SharePoint 2013 with Quiet Command Line Installation for scripting

To perform a quiet installation:
Open a command prompt with administrator permissions.
Run the following command:

Msiexec.exe /i spPowerPivot.msi /q


You can use the /q or /quiet switches for a “quiet” installation that will not display any dialogs or warnings.


Comments

Post a Comment

Popular posts from this blog

Tab Control in Asp.Net

Scenerio: I need your help in designing tab control in   asp.net .My requirement is I need a tab control in   asp.net (C#) like  for example goto my computer ,right click c drive and select properties.we get tabs like general,security etc....... like that i need to design one tab control(no need of any rightclick) in my web page and the database table columns should come as tabs and inseide the tab data of that particular column should come.   Example:Employee master tab1:Employee name.........his name in the tab tab2:Age.............his age tab3:Address........his address   Solution:   You can do this using a simple div <style type="text/css"> .tabs         {             position: relative;             height: 20px;             margin: 0;   ...
Post a Comment
Read more

AI and Microsoft: Revolutionizing Efficiency in Nonprofit Organizations

  How AI and Microsoft Enhance Efficiency in Nonprofit Organizations In today’s fast-paced world, nonprofit organizations face unique challenges—limited resources, increasing demands, and the constant need to do more with less. But what if technology could be the game-changer they need? In my latest research paper,  "How AI and Microsoft Enhance Efficiency in Nonprofit Organizations" , I explore how cutting-edge technologies like Artificial Intelligence (AI) and Microsoft’s innovative tools are revolutionizing the way nonprofits operate. From streamlining administrative tasks to enhancing donor engagement and optimizing resource allocation, AI and Microsoft’s solutions are empowering nonprofits to focus on what truly matters—their mission. This paper dives deep into real-world examples, practical applications, and the transformative potential of these technologies. Whether you’re a nonprofit professional, a tech enthusiast, or simply curious about the intersection of technolo...
Post a Comment
Read more

Social tagging overview in Sharepoint 2010

A tag is a word or phrase that identifies an individual piece of information according to a set of attributes or criteria. Tags make it easy to find and share information about a specific subject or task. Social tagging helps users categorize information in ways that are meaningful to them. Social tagging can improve the quality of search results by filtering against specific tags, and it can also connect individuals who want to share information with other users who have like interests. This article describes the social tagging features in Microsoft SharePoint Server 2010. This article does not describe how to configure social tagging features. It also does not discuss how to implement social tagging features as part of an overall social media strategy for an enterprise. About using social tagging features Social tagging features help users to share information and to retrieve relevant, high-quality content more efficiently. Such sharing encourages collaboration and b...
295 comments
Read more