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 [...]
Archive for November, 2009
Troubleshooting #PowerPivot Excel Services connectivity
Posted in PowerPivot, tagged Connectivity, Excel Services, SharePoint on November 18, 2009 | 5 Comments »
SharePoint Prerequisite Lab Installation Tip (#PowerPivot CTP3 Install)
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 [...]
New Location
Posted in Uncategorized on November 10, 2009 | 100 Comments »
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?
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 [...]
Understanding why an Excel PowerPivot workbook is so large
Posted in PowerPivot, tagged Excel, workbook on November 7, 2009 | Leave a Comment »
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 [...]
Hadoop on Azure
Professional Microsoft PowerPivot for Excel and SharePoint
-
Recent Posts
-
Top Posts
- Update SharePoint 2010 Farm Credentials Tips
- SQL BI at Hadoop Summit = Awesomesauce!
- How to Connect Report Builder 3.0 to a SQL Server 2012 PowerPivot workbook
- SSIS global variables and execute process task
- Troubleshooting #PowerPivot Excel Services connectivity
- Failed to provision the SharePoint Central Administration Web Application
- MDX: Count number of dimension members
- Installing Hadoop on OSX Lion (10.7)
- Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud
- Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 1 of 3)
Categories
Tags
Archives
- May 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- March 2011
- January 2011
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- July 2009
- May 2009
- April 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- July 2008
- June 2008
- April 2008
- February 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- December 2006
- November 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- November 2005
- October 2005
- September 2005
- June 2005
@dennylee
- #SQLBI at @HadoopSummit = #Awesomesauce ! wp.me/pHDEa-gH #Hadoop #BigData #SSAS 8 hours ago
- “@HuffingtonPost: Self-help lessons from a two-year-old huff.to/LtzjJi” > yes, I shall do it! 1 day ago
- wow “@mpanzarino: “@asymco: Apple sells its inventory every 5 days. Second fastest only to McDonald's. asym.co/KQnooc” That's nuts.” 2 days ago
- Thank (not evict) our soldiers! “@nytimes: The Appraisal: Afghanistan Veteran Could Lose Home Over Service Dog nyti.ms/KK7Ruc” 2 days ago
- Get it! “@tom_e_white: It's out. #Hadoop: The Definitive Guide, 3rd Edition. oreil.ly/LXTfdT What's new: bit.ly/LXTiWY” 2 days ago
Copyright
