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:

At TechReady and want a chance to get a PowerPivot Technical Diagram AND win a PowerPivot book?

Are you coming to TechReady and interested in getting yourself a PowerPivot Technical Diagram: PowerPivot Client/Server Architecture? Well, make sure to come to Dave Wickert and my session for a chance to get a printed copy of this awesome diagram!: BIN403: PowerPivot for SharePoint Power Hour…so powerful its 75min 7/30 10:30-11:45am, Sheraton Metro B You’ll also get a chance to win one of two copies of the Professional Microsoft PowerPivot for Excel and SharePoint book as well! Enjoy and see ya there!

Rate this:

PowerPivot, Analysis Services, and TechReady….and coffee!

If you’re going to TechReady 11 at the Washington State Convention Center this week in warm, sunny Seattle – first of all, welcome to the Emerald City!  And if you’re a coffee snob like me (to give you background, not only am a long time Seattle resident so I pretty much breathe coffee – but I also used to live in Montréal so we’re real coffee snobs there, eh?!) – the best place for coffee without a doubt is Espresso Vivace!  The closest one is the one across from REI but there is also two on Broadway in Capital Hill. …

Rate this:

PowerPivot, you are so insensitive! (case that is)

Working with my compatriots Ayad Shammout (@aashammout) and Peter Myers, we had found out that PowerPivot at times can be really insensitive…in terms of case that is.  That is by default, the collation for PowerPivot is case-insensitive. For example, if you import the table below: Within the PowerPivot window, you’ll notice that the lower case “a” has now become an upper case “A”.  If “a” had come before “A”, then both rows would be “a” instead of “A” 😉 Why are you so in-sensitive? Actually, it isn’t THAT in-sensitive.  When importing, the PowerPivot client picks up the regional settings and…

Rate this: