With the upcoming release of SQL Server 2012, the new and cooler way to connect to a PowerPivot workbook within SharePoint is to use Power View which addresses the concept of Self Service Reporting (similar to how PowerPivot addresses Self Service BI). I even have a cool YouTube video showing how to connect Power View [...]
Archive for the ‘SharePoint’ Category
How to Connect Report Builder 3.0 to a SQL Server 2012 PowerPivot workbook
Posted in Analysis Services, Reporting Services, SharePoint on March 25, 2012 | Leave a Comment »
Delegation, Claims, Active Directory…Oh My!…Aw Crap!
Posted in PowerPivot, SharePoint, tagged Active Directory, Configuration, Delegation, Excel Services, FAQ, Troubleshooting, Upgrade on April 8, 2010 | 8 Comments »
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 [...]
Update SharePoint 2010 Farm Credentials Tips
Posted in PowerPivot, SharePoint, tagged Configuration on April 8, 2010 | 4 Comments »
Within your SharePoint environment – such as your PowerPivot for SharePoint single server install – a common task that you will need to do is to update the SharePoint Farm credentials when the password changes. You may be able to do this automatically by using the new SharePoint 2010 feature to plan automatic password change. [...]
PowerPivot for SharePoint Quick tip: Don’t forget to install Desktop Experience
Posted in PowerPivot, SharePoint, tagged FAQ on February 17, 2010 | 1 Comment »
For those of you who are using Windows 7 client, you should be good-to-go already because you already have Desktop Experience installed. But if you are using a Windows Server OS (e.g. Windows Server 2008, Windows Server 2008 R2), you will need to install it as part of an additional feature via the Server Manager. [...]
Handling Cross-forest deployments
Posted in SharePoint, tagged Configuration, Domain, Forest on April 9, 2009 | Leave a Comment »
In many corporate or external-facing SharePoint deployments, it becomes necessary to develop multiple forests or domains to handle different users. A great explaination of this concept can be found in the SharePoint Team’s blog on Support for Cross-forest deployments. The basic idea here is that you have two domains, e.g. DomainA and DomainB. DomainA [...]
Handling Cross-forest deployments
Posted in SharePoint on April 8, 2009 | 100 Comments »
In many corporate or external-facing SharePoint deployments, it becomes necessary to develop multiple forests or domains to handle different users. A great explaination of this concept can be found in the SharePoint Team’s blog on Support for Cross-forest deployments. The basic idea here is that you have two domains, e.g. DomainA and DomainB. DomainA [...]
Failed to provision the SharePoint Central Administration Web Application
Posted in SharePoint, tagged Configuration on February 19, 2009 | Leave a Comment »
In this situation, I ended up getting the error message: Failed to provision the SharePoint Central Administration Web Application My setup is a Windows Server 2008 Enteprise x64 box with SQL Server 2008 – attempting to configure my recently installed SharePoint 2007. That should have done the trick but I ended up getting the [...]
Failed to provision the SharePoint Central Administration Web Application
Posted in SharePoint on February 18, 2009 | 100 Comments »
In this situation, I ended up getting the error message: Failed to provision the SharePoint Central Administration Web Application My setup is a Windows Server 2008 Enteprise x64 box with SQL Server 2008 – attempting to configure my recently installed SharePoint 2007. That should have done the trick but I ended up getting the [...]
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
