Monday, February 16, 2015

Project Server 2013: Project data not showing in BI reports after migrating from Project Server 2010

Recently, upon migrating a PWA instance from Project Server 2010 to Project Server 2013, I noticed the BI reports were showing blank for Project data. For example, the SimpleProjectsList sample report would successfully open without any errors, but it was just blank. Furthermore, I could successfully connect to the PWA site and get Project data via an OData Data Feed using my Excel 2013 client application.

After opening a ticket with Microsoft, we discovered the projects were not published correctly. We managed to publish the 400+ projects correctly using an Microsoft issued application named ProjTool. You can download ProjTool and user instructions in the zip file below.

Hope this helps others facing this same issue.

No comments:

Post a Comment