background preloader

Power Pivot

Facebook Twitter

Configure Excel Services 2010 for data refresh « Howard @ MSFT selling BI. October 2010. PowerPivot Workbook has 2 kinds of data sources, one is from its Pivot table cache, and the other is from PowerPivot Analysis Cubs.

October 2010

Then what about Data Refresh? PowerPivot Data Refresh is to refresh Analysis Cubs from external data sources, and as part of this refresh process, the workbook is updated as well. The credential used for data refresh can be: Unattended account, embedded window credential, or SSS Notice, there is no window authentication listed above, which means the logon user credential is never used for data refresh. So obviously data in Analysis Service is not security trimmed. Also notice, it is PowerPivot System Service which retrieves data refresh credential and then sends to Analysis Service, since both PowerPivot and Analysis Service are guaranteed running on the same server, Analysis Service can delegate this credential further to external datasource without need of kerberos delegation. How to: Install PowerPivot for SharePoint on an Existing SharePoint Server. The SharePoint server must have been installed using the Server Farm installation option in SharePoint setup.

How to: Install PowerPivot for SharePoint on an Existing SharePoint Server

A standalone SharePoint server that uses a built-in database is not supported. For more information, see Guidance for Using SQL Server BI Features in a SharePoint Farm. PowerPivot for SharePoint must be installed. At a minimum, the farm solution must be deployed. Use either the PowerPivot Configuration tool or PowerShell script to deploy the farm solution. The computer must be joined to a domain. Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’. « PowerPivotGeek. By Lee Graber (, on January 20th, 2010 A number of people have hit this issue and so it deserves a quick walkthrough of why it (unfortunately) can happen and how you fix it.

Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’. « PowerPivotGeek

The error occurs when you try to select a Document Library of type PowerPivot Gallery (sometimes referred to as Report Gallery). After installing Power Pivot for SharePoint, all new site collections you create have the option to create a new document library of this type and if you use the PowerPivot Site template when creating the site collection, we automatically add a library of this type (that is the main thing we do in this template). The data connection uses Windows Authentication and user credentials could not be delegated « PowerPivotGeek. By Lee Graber (, on February 8th, 2010 This is one of the two main errors that users could see from Excel Services when using PowerPivot.

This is encountered when refreshing PowerPivot data connections or performing an action which requires re-querying the PowerPivot database, such as clicking on a slicer or expanding a node in a pivot table. To debug, some level of understanding of what Excel Services is doing is required. PowerPivot SharePoint Integration Install Bug - All things SQL Server Related.... I have recently been doing a lot of work with PowerPivot, and installing it at customers site. I have on two occasions now come across the below error message: Error: Your SQL Server 2008 R2 installation completed with failures. Object reference not set to an instance of an object. When you view the detail.txt error log, check to see if you see the below towards the bottom of the log: 2010-08-20 14:03:38 AS: Updating IMBI Version of Engine Service instance on local machine failed.

Then you are experiencing a setup bug. Workaround: To rectify this issue, I manually created the directory (shared directory at the following location - C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies) and ensured that the Microsoft.AnalysisServices.SharePoint.Integration.DLL file exists. Existing Farm Install (RTM) « PowerPivotGeek. The final version of the PowerPivot for SharePoint – Existing Farm Installation Guide has now been posted on Microsoft’s download site.

Existing Farm Install (RTM) « PowerPivotGeek

Modifying the SharePoint v4.master page for the PowerPivot Gallery « PowerPivotGeek. By powerpivotgeek (, on June 17th, 2010 Attempting to use a modified version of the SharePoint v4.master page is a great way to style our SharePoint site.

Modifying the SharePoint v4.master page for the PowerPivot Gallery « PowerPivotGeek

If you interested in doing this, then the first thing to do is to make sure that you go to the right place: Go to Site Settings -> Site Collection Features -> Make sure “SharePoint Server Publishing Infrastructure” is activated. Go to Site Settings -> Manage Site Features -> Make sure “SharePoint Server Publishing” is activated.Finally then on the Site settings page, you should get an entry for Master Page under the “Look and feel” section. Modifying the master page works fine for the landing page, document libraries, calendar and other pages—but causes an error with the PowerPivot Gallery. Excel Services delegation « PowerPivotGeek. By powerpivotgeek (, on December 11th, 2009 I am inspired by a recent post from a colleague about the various issues that can come up with Excel Services delegation (see a Denny Lee’s blog here: and I wanted to take it a bit further (and maybe a bit ‘geekie’-er) First, why is this a problem?

Excel Services delegation « PowerPivotGeek

After all, as you can see in Denny’s post, you can see the workbook and you even have a thumbnail for it in the Gallery. What’s up here? The core of the problem is that unless you’ve set the connection to refresh when you first open the workbook, Excel Services uses its pivot cache to construct the pivot table and slicers.

Ok, so now we’ve hit the problem. How to: Install PowerPivot for SharePoint and Reporting Services. [This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.] Reporting Services and PowerPivot for SharePoint are two feature components of SQL Server that are installed separately but can be used together in a SharePoint 2010 environment. By deploying both feature components in the same farm, you enable the following scenarios: Ability to view and manage both workbooks and reports from the same SharePoint sites and libraries, using the same SharePoint permissions and policies to control access to your business documents.

Ability to create Report Builder reports from PowerPivot workbooks that are stored within the same SharePoint library. PowerPivot for SharePoint and Reporting Services are separate features that you install and configure independently of each other. This topic contains the following sections: Prerequisites Overview.