Monthly Archives: January, 2010
Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 3 of 3)
Background This blog posting is a continuation of previous post, Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3), where I had created an … Continue reading
Reading your #PowerPivot Profiler trace
To help troubleshoot your PowerPivot for Excel workbook, you can click on Settings within the PowerPivot selection in the Office Ribbon which will bring up the Support & Diagnostics tab … Continue reading
Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 2 of 3)
Background This blog posting is a continuation of previous post, Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3), where I had created an … Continue reading
Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 1 of 3)
Background I was recently working with a customer to help them solve an interesting PowerPivot problem where they had wanted to get the Top 10 users within their data set … Continue reading
#PowerPivot Data Refresh SSRS Report
As many of you already know, in order to figure out which workbooks had succeeded or failed execute in their data refresh, you need only to go the PowerPivot Management … Continue reading
How do I get the menu options for individual reports within the #PowerPivot Gallery?
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 – … Continue reading
Pros/Cons of deploying #SSIS with the SQL engine server
I was asked a pretty good question recently on what are the pros and cons of deploying SQL Server Integration Services packages on the same server that has your SQL … Continue reading
The Great #PowerPivot FAQ is now accepting applications
Just in case you didn’t already know from the tweets, I figured I’d also give a shout out (again) to the “Great PowerPivot FAQ” and note the fact that it … Continue reading
The Great PowerPivot FAQ!
Just in case you’re not already aware of this, some of great contributors to the PowerPivot community are now adding and moderating to the Great PowerPivot FAQ. Please check it … Continue reading
Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI
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. … Continue reading
Quick Tips for clearing up space #PowerPivot for SharePoint Uploading
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 … Continue reading
More great PowerPivot resources!
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 … Continue reading
