Archive Page 2

Don’t forget your Central Admin when creating AAM entries

Published August 2, 2010 Configuration Leave a Comment
Tags: ,

By powerpivotgeek (dwickert@hotmail.com), on August 2nd, 2010

(my thanks to Dan English http://denglishbi.spaces.live.com/ for the solution in this post)

Dan’s system failed trying to bring up the Workbook Activity or Server Health workbooks as part of the PowerPivot Management Dashboard in Central Admin. The error was: “The file that you selected could not be found. Check the spelling of the file name and verify that the location is correct”. The file was there; he could be seen it using WebDAV “\\ServerName@CAPort#\PowerPivot Management\<guid for service application>\1033\Workbook Activity.xlsx” or the UI:

Please click through to continue reading Don’t forget your Central Admin when creating AAM entries

If running on Windows Server, make sure you have ‘Desktop Experience’ feature turned on

Published July 12, 2010 Configuration , Installation Leave a Comment
Tags:

By powerpivotgeek (dwickert@microsoft.com), on July 12th, 2010

Oh the joys of SharePoint again. I just responded to an internal posting where someone was raising the issue that “Path not found” errors were being reported when Excel Desktop tried to publish a workbook to SharePoint. Again, this isn’t PowerPivot directly, but it can be reported as a PowerPivot problem if the workbook contains PowerPivot data.

Continue Reading: If running on Windows Server, make sure you have ‘Desktop Experience’ feature turned on 

Using a SharePoint list as a data source

Published July 12, 2010 Configuration , Installation Leave a Comment
Tags:

By powerpivotgeek (dwickert@microsoft.com), on July 12th, 2010

So . . . here I am playing around with PowerPivot to get ready for a demo. As this is a group from the SharePoint dev team (actually SharePoint Online), I wanted to include some cool SharePoint functionality into the demo. Trying to be cool and ‘wow’ them, I decide to use a SharePoint list as a data source. I want to show the data mashup capabilities of PowerPivot so I have the bulk of my demo come from the Contoso sample database (the three product catalog tables) and the 4 million row Sales Fact table.

I create my SP list by extracting the 11 distinct manufacturers – and I assign them to a ‘shipper’ that I made up.

Continue reading: Using a SharePoint list as a data source

Incoming emails to a PowerPivot Gallery

Published July 12, 2010 Internals Leave a Comment
Tags: ,

From time to time you run into something on SharePoint that is a known SharePoint ‘issue’, but you wouldn’t necessarily see PowerPivot being impacted. After all SharePoint is this huge juggernaut of a product and PowerPivot is just this one small little app in the corner. Well, here is one that I ran into today. We had a bug report that the incoming email setup for a PowerPivot Gallery was missing the ‘incoming emails’ link –> after some searching, I found this interesting posting:

Click through to continue reading.

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

Published June 18, 2010 Internals , Perspectives Leave a Comment
Tags: , ,

June 18, 2010 by dennyglee

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:

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

Client: What happens if I install the wrong ‘bitness’?

Published June 17, 2010 Configuration , Installation Leave a Comment
Tags: , , ,

By powerpivotgeek (dwickert@microsoft.com), on June 17th, 2010

Recently ran into this situation: Customer installed the wrong PowerPivot bits on their machine. They were running on a 64-bit OS with Office 2010 x64, but installed PowerPivot for Excel 32-bit. Everything installed OK, but when they clicked on the PowerPivot tab in Excel; then the PowerPivot Window they received the following error:

Click through to continue reading.

Modifying the SharePoint v4.master page for the PowerPivot Gallery

Published June 17, 2010 Configuration Leave a Comment
Tags: ,

By powerpivotgeek (dwickert@hotmail.com), on June 17th, 2010

Attempting to use a modified version of the SharePoint v4.master page is a great way to style our SharePoint site.  If you interested in doing this, then the first thing to do is to make sure that you go to the right place:

Click through to continue reading

Installing and Uninstalling PowerPivot does WHAT?

Published June 14, 2010 Configuration , Installation Leave a Comment
Tags: , ,

PowerPivotGeek has posted some mightly good stuff concerning the installation and uninstallation of PowerPivot. The quick summaries are:

Compliments of PowerPivotGeek!

Changing service accounts and handling password resets

Published June 14, 2010 Configuration Leave a Comment
Tags:

By powerpivotgeek (dwickert@microsoft.com), on June 14th, 2010

While this is technically a pure SharePoint posting, we have found it useful in our labs. We have password resets all of the time and this cheat sheet was developed to make it as painless as possible. I hope you find it as useful as we do.

Please click to continue reading.

–

Side Note: As well, there is an in depth discussion on Changing Passwords in Chapter 9 of Professional Microsoft PowerPivot for Excel and SharePoint.

Why is allocation always selecting the same machine?

Published June 14, 2010 Configuration , Internals Leave a Comment
Tags: , ,

By powerpivotgeek (dwickert@microsoft.com), on June 14th, 2010

If you are running PowerPivot for SharePoint on more than one backend app server, then it is a common issue that folks are seeing only one server being used. It turns out that this might be ‘by-design’ so let’s talk about it for a bit. Let’s look at the two allocation methods we support:

  • Round-Robin
  • Health-Based

Please click to continue reading.

« Previous Page — Next Page »

Denny Lee’s Tweets (1/2 of PowerPivot Twins!)

Copyright

Copyright © 2010 Denny G Lee - All Rights Reserved
Follow

Get every new post delivered to your Inbox.