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…
Month: November 2009
SharePoint Prerequisite Lab Installation Tip (#PowerPivot CTP3 Install)
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 not have internet connectivity, this step will fail because it is trying to download the required files. Within the installer dialog, it will provide you a link to the installation log. Search for “download” within the file and you can then identify the component…
New Location
After pondering for awhile, I had decided to create a new blog using WordPress and have shifted the blogs to my new site. Come check it out at: http://dennyglee.com. Thanks!
What happens when you run a Data Refresh within #PowerPivot for SharePoint?
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 xlsx is updated by SharePoint during data refresh, is that step subject to the 2GB file limit? and I thought it made sense if that we share this answer as well. So the answer is “Yes”. … Details you ask? Okay, here are the…
Understanding why an Excel PowerPivot workbook is so large
During my and Dave Wickert’s SQLPASS session (SQLCAT: A Preview to PowerPivot Best Practices), we had shown to the audience how to view and better understand the PowerPivot database file structure within the Excel workbook. First of all, I’d like to give credit where credit is due – and the thanks really should go to Ashvini Sharma – Power Pivot, Analysis Services, and Integration Services Dev MasterMind. So while the presentation piece is ours – the actual knowledge and know how is his . Saying this, what do we mean by all of this? Read More…
Presentation: SQLCAT: Addressing Security and Compliance Issues with SQL Server 2008
This is Il Sung Lee, Ayad Shammout, and my 2009 SQL PASS Summit presentation on addressing security and compliance issues with SQL Server.
Presentation: SQLCAT: A Preview to PowerPivot Server Best Practices
This is Dave Wickert and my PASS 2009 presentation on a preview to PowerPivot Server Best Practices.
Denny Lee 