For those who would like a quick primer on PowerPivot Topologies and Configurations, check out the SlideShare below. Enjoy!
Tag: Excel Services
Dude, Where’s my PowerPivot workbook?
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 SkyDrive. What we’re referring to here is the fact that you went ahead and saved your PowerPivot workbook to the SharePoint, typically through the Excel Save As or Save to SharePoint function as noted in the posting: Uploading #PowerPivot for Excel workbook using “Save As”…
Delegation, Claims, Active Directory…Oh My!…Aw Crap!
Heads up, this posting’s title was “User credentials could not be delegated and Active Directory” but I realized I needed a title that evoked my emotional state 😉 Do not fret or worry, this is not “yet another user credentials delegation” blog. After all, there are already the postings including Troubleshooting #PowerPivot Excel Services connectivity (written by yours truly) and Excel Services delegation (by PowerPivotTwins partner Dave Wickert). More importantly, if you want to debug and troubleshoot your way through the PowerPivot / Excel Services delegation issues, the coup-de-grace is Lee Graber’s excellent post: that The data connection uses…
Ramblings about missing time … and #PowerPivot sneak peek!
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 I do have a good excuse! Really! Oh, and for those of you patient enough to read to the end, I do have an interesting sneak peek for you 🙂 RTM… aaaaaaahhhhhh!! RTM is driving me nuts…but then again, Dave Wickert (PowerPivotGeek) has been handling…
Granting Excel Services access rights to your #PowerPivot for SharePoint Farm
In many of test PowerPivot for SharePoint deployments, the SharePoint Farm Administrator is used for all services including Excel Services during installation or configuration. This is a great and easy way to get yourself up and running fast. But a best practice is to use a different managed account for the application pool that Excel Services (and PowerPivot Services for that matter) is running under. This way Excel Services (and other services using that application pool) do not have Farm Administrator rights. But in the process of doing this, one might have forgotten to grant Excel Services rights to the…
Troubleshooting #PowerPivot Excel Services connectivity
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 click on a slicer, and then all of a sudden you get an error like the one below. What can you do? Well, for starters, the key thing is to %commonprogramfiles%\Microsoft Shared\Web Server Extensions\14\LOGS\ folder and review the ULS logs which contain a lot…
Denny Lee 