Because PowerPivot for Excel and PowerPivot for SharePoint involves so many components from SQL Server 2008 R2 Analysis Services, Office 2010, and SharePoint 2010, this poster provides an end-to-end view of the PowerPivot Security Architecture in one view. This view includes nearly all of the logical security surface areas and illustrates how these systems interact.
Included in this diagram are:
- Service Accounts
- SharePoint Databases
- Security Hardening
- Automatic Data Refresh
- User Identity Flow
- PowerPivot Permissions Levels
Please click through to continue reading: PowerPivot Technical Architecture Diagram
By powerpivotgeek (firstname.lastname@example.org), on August 22nd, 2010
Recently a question has come up on one of the forums about the number of rows that PowerPivot can load. Clearly PowerPivot can hold a lot – just look at our demos. Millions and millions . . ah . . but how many millions?
The key geek ‘magic’ is the Vertipaq engine. The in-memory Vertipaq engine has an extensive array of techniques that it uses for compressing and manipulating the data. Being an in-memory database system means that the more data that we can get in . . the more data we can scan . . the more kinds of applications that we can solve. So compression is a HUGE deal for us.
Please click through to continue reading: How much data can I load into PowerPivot?
August 21, 2010 by dennyglee
One of the cool things with PowerPivot is to click on an SharePoint List’s Export as Data Feed (i.e. an ATOM feed) and its data can be imported directly into a PowerPivot for Excel workbook. To get this thing to work, one of the key things that I remind people regularly is to make sure you install ADO.NET Data Services Update for .NET Framework 3.5 SP1.
So after doing this multiple times, I proceeded to do my usual atom feed import like I usually do:
Please click through to continue reading Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!
By powerpivotgeek (email@example.com), on August 21st, 2010
From time to time I get questions from folks asking me “What is the best debugging tool for PowerPivot?” – The Answer is that there is clear cut favorite and it is EXTREMELY useful, but I didn’t know that it was released to the public. Well . . . after some investigation, it looks like it is available – not only that, it has been for a while. But better late than never . . take a look at it!
Please click through to continue reading SharePoint 2010 revised ULSViewer
Published August 18, 2010
Configuration , Internals
Tags: ACE, FAQ, SharePoint
By powerpivotgeek (firstname.lastname@example.org), on August 18th, 2010
Ok. I’ve promised some best practices – here is my first one.
What is the 2010 Office ACE provider and why is this important to PowerPivot? The 2010 Office System Driver for Data Connectivity Components (aka the Office ACE provider) is a OLE DB provider that can be used to read data from and write data to Office 2010 system files such as Microsoft Access Beta (mdb and accdb) files and Microsoft Excel 2010 (xls, xlsx, and xlsb) files. You can also use it to access text files.
Click through to continue reading Working with the 2010 Office ACE provider
By powerpivotgeek (email@example.com), on August 2nd, 2010
(my thanks to Dan English http://denglishbi.spaces.live.com/ for the solution in this post)
Dan’s system failed trying to bring up the Workbook Activity or Server Health workbooks as part of the PowerPivot Management Dashboard in Central Admin. The error was: “The file that you selected could not be found. Check the spelling of the file name and verify that the location is correct”. The file was there; he could be seen it using WebDAV “\\ServerName@CAPort#\PowerPivot Management\<guid for service application>\1033\Workbook Activity.xlsx” or the UI:
Please click through to continue reading Don’t forget your Central Admin when creating AAM entries
From time to time you run into something on SharePoint that is a known SharePoint ‘issue’, but you wouldn’t necessarily see PowerPivot being impacted. After all SharePoint is this huge juggernaut of a product and PowerPivot is just this one small little app in the corner. Well, here is one that I ran into today. We had a bug report that the incoming email setup for a PowerPivot Gallery was missing the ‘incoming emails’ link –> after some searching, I found this interesting posting:
Click through to continue reading.
PowerPivotGeek has posted some mightly good stuff concerning the installation and uninstallation of PowerPivot. The quick summaries are:
Compliments of PowerPivotGeek!
By powerpivotgeek (firstname.lastname@example.org), on June 14th, 2010
If you are running PowerPivot for SharePoint on more than one backend app server, then it is a common issue that folks are seeing only one server being used. It turns out that this might be ‘by-design’ so let’s talk about it for a bit. Let’s look at the two allocation methods we support:
Please click to continue reading.
May 23, 2010 by dennyglee | Edit
As you may have noted in my original posting Delegation, Claims, Active Directory…Oh My!…Aw Crap!, it quickly described how to solve issues surrounding the delegation of the claims token within an Active Directory environment. In it I referenced Lee Graber’s excellent posting: The data connection uses Windows Authentication and user credentials could not be delegated.