The functionality in Excel’s PowerPivot is wonderful. My favorite is the ability to add columns that contain functions, and I use this frequently for client reports.

So, this is all great.  New functionality, happy clients . . . however, when I create a powerpivot data model that overlays the pivot table I display, I can no longer edit my data connection in the pivot table! This is an issue whenever I want to add a new column from the database, add hard-coded filters, etc.

Here’s where it’s hiding.  Open the PowerPivot. Click on the Design tab and select Table Properties.

Your connection string will appear in edit-able format. Modify, save and enjoy!

Want to learn more about Project Server Business Intelligence? Here are two helpful resources on our Business Intelligence Page:

Download our Reporting Quick Reference Guide

Download the Business Intelligence and Reporting Solution Guide