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 [...]
Posts Tagged ‘SharePoint’
PowerPivot for SharePoint: Single Server Installation
Posted in PowerPivot, tagged SharePoint, Installation on August 30, 2010 | Leave a Comment »
Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!
Posted in PowerPivot, tagged SharePoint, Troubleshooting on August 21, 2010 | Leave a Comment »
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 [...]
PowerPivot Technical Diagram: PowerPivot Security Architecture
Posted in PowerPivot, tagged SharePoint, Architecture on August 18, 2010 | Leave a Comment »
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!
Dude, Where’s my PowerPivot workbook?
Posted in PowerPivot, tagged Connectivity, Excel Services, SharePoint on April 14, 2010 | Leave a Comment »
In homage to Rob Collie’s blog posting style (yes!…he has style, he has grace, …) and of course the movie “Dude, Where’s my Car?”, let’s ask a new question: Dude, where’s my PowerPivot workbook? And before you ask, we’re not talking about searching for the workbook somewhere in your “My Documents” folder, USB drive or [...]
Ramblings about missing time … and #PowerPivot sneak peek!
Posted in PowerPivot, tagged Book, Configuration, Connectivity, Design, Excel Services, FAQ, Internals, SharePoint, Troubleshooting on April 5, 2010 | 4 Comments »
Wow, I just checked and its been more than a month since I did my last blog post! So for starters, apologies for the lack of cool PowerPivot stuff on this blog. But it’s not like I haven’t been tweeting about PowerPivot…thank goodness I can easily retweet or type 140 characters! (follow me @dennylee) But [...]
How do I get the menu options for individual reports within the #PowerPivot Gallery?
Posted in PowerPivot, tagged FAQ, SharePoint on January 15, 2010 | 1 Comment »
When you start playing with the PowerPivot Gallery, some of you will be enamored by the various views of the Silverlight control included as part of the PowerPivot Gallery – I know I was! But if I want to modify or view the properties of the individual report – how do I do this? Well, [...]
Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI
Posted in PowerPivot, tagged Excel, SharePoint, Troubleshooting on January 6, 2010 | 2 Comments »
When you save a PowerPivot for Excel workbook by using the “Save As” function with Excel, this will use the Office Upload Center as its mechanism to save the file. This is different than uploading the file by using the SharePoint UI as the SharePoint UI uses a different mechanism via http to upload the [...]
Quick Tips for clearing up space #PowerPivot for SharePoint Uploading
Posted in PowerPivot, tagged SharePoint, Tuning on January 6, 2010 | 2 Comments »
When you upload your PowerPivot for Excel workbook to your PowerPivot enabled SharePoint site, you typically will deal with much larger files than your other SharePoint sites. This is the reason why we suggest that you increase the Excel Services and SharePoint to the max file sizes allowed (to do this, follow Step 18 at [...]
More great PowerPivot resources!
Posted in PowerPivot, tagged Configuration, SharePoint, Video on January 5, 2010 | 1 Comment »
As you already may know, we have a couple of forums for PowerPivot at: SQL Server 2008 R2 PowerPivot for Excel SQL Server 2008 R2 PowerPivot for SharePoint Dave Wickert with his PowerPivotGeek.com site has also created two new sections: Reported Problems section which compiles the different issues concerning PowerPivot for SharePoint installations and Troubleshooting [...]
Troubleshooting #PowerPivot Excel Services connectivity
Posted in PowerPivot, tagged Connectivity, Excel Services, SharePoint on November 18, 2009 | 4 Comments »
You’re on your way to PowerPivot for SharePoint functionality – you’ve uploaded your PowerPivot for Excel workbook to your SharePoint PowerPivot Gallery. You view the thumbnails of your report and they look nice. From the thumbnail, you click on the report you want to see, and the report renders nicely. But then you [...]

