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, it’s [...]
Posted in PowerPivot, tagged Excel, SharePoint, Troubleshooting on January 6, 2010 | 1 Comment »
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 [...]
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 [...]
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 section which complies [...]
Posted in PowerPivot, tagged Connectivity, Excel Services, SharePoint on November 18, 2009 | 3 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 click on [...]
Posted in PowerPivot, tagged CTP3, SharePoint on November 11, 2009 | 6 Comments »
When you install SharePoint Beta 2 to go with your PowerPivot for SharePoint CTP3 install, some will install SharePoint on a set of servers (or VMs) that do not have internet connectivity.
The first step to installing SharePoint Beta 2 is to run the SharePoint Prerequisite Installer. If you are in a lab environment that does [...]
Posted in PowerPivot, tagged Data Refresh, Internals, SharePoint on November 8, 2009 | Leave a Comment »
I was just recently asked the question by a fellow Analysis Services expert (Greg Galloway):
When you have SharePoint automate a data refresh for a PowerPivot workbook, is the new data saved back into the xlsx? So if I download the xlsx onto my laptop the next day, will I see fresh data? Also, if the [...]
