none
Refreshing the PWA SQL database table list RRS feed

  • Question

  • Dear Project Server users,

    I have a PowerPivot Excel workbook connected to the PWA SQL database, and have oppened the EPM Project User view table. When I create a new project custom field in PWA and refresh all connections in the workbook, the new custom field is not visible.

    When I create a new connection to the PWA SQL database I can see the new custom field.

    Is there a way to somehow refresh and get the new custom fields or I have to make a new connection every time.

    Sincerely,
    Petar 

    Tuesday, November 8, 2016 12:30 PM

Answers

  • Here's the solution.

    http://www.keepitsimpleandfast.com/2011/04/how-to-update-your-powerpivot-field.html
    • Marked as answer by PetarB Tuesday, November 8, 2016 1:19 PM
    Tuesday, November 8, 2016 1:19 PM