For those who would like a quick primer on PowerPivot Topologies and Configurations, check out the SlideShare below. Enjoy!
Tag: SharePoint
Presentation: Deploying and Managing PowerPivot for SharePoint
This is Dave Wickert and my 2010 PASS Summit presentation on deploying and managing PowerPivot for SharePoint.
Can I access PowerPivot via a data access API?
I recently got asked the question: Does PowerPivot have any data access APIs? Is there any way to to programmatically access the data store? I figured that a lot of people will eventually ask this question (heck, that’s what I had asked when I had first heard about PowerPivot). The answer as of 2010 is: Right now, there is no supported way to access the data store within Excel as all PowerPivot for Excel APIs are private. Saying this, the data store backup is stored within Excel itself as per the posting For Excel PowerPivot, the database is IN…
PowerPivot for SharePoint: Existing Farm Installation
So the fate… of the entire human race depends upon my wild guess — Doctor Gaius Baltar (Battlestar Galactica) Actually, the quote that I really wanted to say was “So the fate… of the entire PowerPivot deployment depends upon my wild a** guess?! WTF!!!” Yet, this is not the time for us to go quietly in the night! Do not go gentle into that good night! (Dylan Thomas) Okay, I’ll stop now. But seriously, PowerPivot for SharePoint for an existing farm installation can be complex and mind numbing at times – especially with the 20…
PowerPivot for SharePoint: Single Server Installation
A long time ago, but not in a galaxy too far away…actually, just in Redmond, WA,… there was A NEW HOPE for easier PowerPivot for SharePoint installations! So hats off to the Analysis Services product team for building an easier PowerPivot for SharePoint installation by providing us with the “New Server” installation choice. Yet, even with the easier installation steps, it is important to make sure you do the steps in the right order and have the correct prerequisites installed to make it a smooth installation experience. During the CTP (Community Technology Preview) process, a number of us had got…
Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!
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. ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows 2000, Windows Server 2003, Windows XP, Windows Vista and Windows Server 2008 ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows…
PowerPivot Technical Diagram: PowerPivot Security Architecture
Just in case you didn’t already know, we just uploaded the PowerPivot Security Architecture technical diagram on to sqlcat.com / MSDN. To get access to the PDF, XPS, and/or VSD files, please click through to: http://sqlcat.com/whitepapers/archive/2010/08/17/powerpivot-technical-diagram-powerpivot-security-architecture.aspx Enjoy!
Dude, Where’s my PowerPivot workbook?
In homage to Rob Collie’s blog posting style (yes!…he has style, he has grace, …) and of course the movie “Dude, Where’s my Car?”, let’s ask a new question: Dude, where’s my PowerPivot workbook? And before you ask, we’re not talking about searching for the workbook somewhere in your “My Documents” folder, USB drive or SkyDrive. What we’re referring to here is the fact that you went ahead and saved your PowerPivot workbook to the SharePoint, typically through the Excel Save As or Save to SharePoint function as noted in the posting: Uploading #PowerPivot for Excel workbook using “Save As”…