(Thanks to Ankur Goyal, one of the PowerPivot mid-tier testers, for this detailed write-up)
You might have noticed that Excel Services sometimes complains about how the PowerPivot workbook is organized. It reports an warning error like this one::
In this posting, I’ll talk about why these rectangles exist (i.e. what they do) and how you can have [...]
As noted in a previous blog post on debugging “The data connection uses windows authentication and user credentials could not be delegated” there are times (very rare times) when the issue is a problem with your Active Directory configuration. I want to reiterate that this is rare and it is usually something as simple as [...]
(Thanks to Ankur Goyal, one of the PowerPivot mid-tier testers)
SharePoint 2010 comes with a whole group of new developer tools. But there is none cooler than the Developer Dashboard. The Developer Dashboard allows you to monitor page load performance on SharePoint. Now how cool is that – you see how each element on the page [...]
I just had a chance to view some very cool demos on the topic of using PowerPivot and data mining together to solve some interesting business problems.
Go see Mark Tabladillo’s YouTube home page: http://www.youtube.com/user/MarkTabNet# or his web site at: http://www.marktab.net/ (which also has a download of the workbooks he is using in his demo.
And the [...]
In another one of those “oh heck, I just spent a couple hours of my life chasing my tail” and in an effort to ‘prepare everyone for RTM’, you might notice the following error pop up from time to time.
And in the NT Event Log you might seen entries like:
An unhandled exception occurred and [...]
Here is a cute trick for all of you ‘client’ jockeys out there. Sometimes you have a table that you, as a designer, have for some limited uses. Maybe the table exists for establishing relationships, or for intermediate calculations, but not for querying. How can you hide it? Well, it turns out that it is [...]
After installing the PowerPivot for Excel add-in there are various things that you can to do attempt to debug the situation:
First, and I know this sounds dumb, but I have to point it out – you have to be using Excel 2010. PowerPivot does not run under earlier version of Excel.
Next ensure that you [...]
This will save you a few hours of debugging. Virtually every SharePoint feature and application, e.g. Excel, PPT, and Word Web Apps, do not support 64-bit browsers. In order to work around this behavior, please use a 32-bit browser. While others have issues around compatibility, this restriction applies to PowerPivot for one HUGE reason. And [...]
Recently I have been seeing some threads about how data is updated in a PowerPivot workbook. As it turns out, this can be a pretty complicated technical situation, so lets start off with a general statement: There are only 2 ways to update the embedded data contained in a PowerPivot workbook:
Bring the workbook down to [...]
As today was “Launch Day” (http://sharepoint.microsoft.com/2010launch/en-us/Pages/home.aspx) for Office 2010, SharePoint 2010 and SQL Server 2008 R2, I was able to pickup a few PowerPivot testimonial videos. I am not a marketing guy; nor do I play one on TV, but these were pretty cool. PowerPivot RULES!
“Excel as a Tool for Business Intelligence”
Information workers want self-service [...]