How to Connect Report Builder 3.0 to a SQL Server 2012 PowerPivot workbook

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 to Hadoop on Azure: https://dennyglee.com/2012/02/10/connecting-power-view-to-hadoop-on-azurean-awesomesauce-way-to-view-big-data-in-the-cloud/ . Why Report Builder 3.0 when there is Power View? Nevertheless, there are some situations where SQL Server 2008 R2 tool – Report Builder 3.0 – can still be quite helpful. For example, if you need to export out the…

Rate this:

Delegation, Claims, Active Directory…Oh My!…Aw Crap!

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 by yours truly) and Excel Services delegation (by PowerPivotTwins partner Dave Wickert).   More importantly, if you want to debug and troubleshoot your way through the PowerPivot / Excel Services delegation issues, the coup-de-grace is Lee Graber’s excellent post: that The data connection uses…

Rate this:

Update SharePoint 2010 Farm Credentials Tips

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.  But if you need to change your farm credentials, you can follow the instructions: How to change service accounts and service account passwords in SharePoint Server 2007 and in Windows SharePoint Services 3.0. But in the process of updating a PowerPivot for SharePoint single server…

Rate this:

PowerPivot for SharePoint Quick tip: Don’t forget to install Desktop Experience

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. Why you ask? Typically when you upload files to SharePoint (including the PowerPivot Gallery), you will do save-as from Excel and/or use the SharePoint UI to upload the file to the URL http://$servername$/PowerPivot%20Gallery/.  But if you want to automate the upload of files, you’ll have…

Rate this:

Handling Cross-forest deployments

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 has your SharePoint servers and you want to be able to add users from DomainB to be allowed access to your site.  An example would be to use the People-Picker on your SharePoint site and you want to add DomainBUser1.  This can work if there…

Rate this: