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…

Rate this:

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…

Rate this:

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…

Rate this:

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…

Rate this:

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!

Rate this: