PowerPivotGeek?

Who is this mystery man?
Click on the icon to find out. Who is powerpivotgeek?

What database support is needed

I get this question a lot and I thought that it was a good one to address here in the blog.

If you look at the PowerPivot for SharePoint architecture, you know that we use several SQL Server 2008 R2 components within the architecture, but how about SharePoint itself . . . What RDBMS does PowerPivot [...]

A photo to liven up your day

For those who I haven’t had a chance to meet at SQL PASS, the SharePoint 2010 Conference, the PNWSQL Users group, or countless other SSAS conferences over the years, I just posted a photo of myself on the About page.

(photo taken by my beautiful daughter Jeannie with her new Nikon D5000 12.3 MP DX DLSR [...]

How to start debugging a PowerPivot for SharePoint installation issue

A number of people have had issues with PowerPivot installation failures in CTP3. Hopefully, we have resolved all of these for RTM, but I can tell you that setup is still a bit tricky. To give you something of an understanding, the “New Farm” installation option is responsible for getting your machine up and running [...]

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

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.

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 [...]

How to manually update your PowerPivot Management Dashboard

We have gotten lots of feedback about the new CTP3 PowerPivot Management Dashboard feature. Most folks are excited about the new reports and can see how the reports give you an unparalleled ability to ‘peek’ inside the running services. However the default “wait-a-day” update cycle can see a bit long. A day-long cycle period seems [...]

Why you shouldn’t stop / start Analysis Services from SCM when running in SharePoint Integration Mode

Hopefully this will be my first of many posts as I have been meaning to try and start doing memory dumps to this blog. Hopefully some of those memory dumps also made it into our docs … I tried.

So most people who are used to using Windows based services are used to using Service Control [...]