Wednesday, October 18, 2017

Microsoft Project Online Power BI Content Pack





With the Project Online Power BI Content Pack content pack, you can expand on the Microsoft Project Online Content Pack. Import and analyze data from Project Online in Power BI. The content pack is designed to help you quickly connect to your Project Online tenant in Office 365 and download a variety of data to visually explore and monitor all the key aspects of your PPM deployment. There are 13 visually rich report pages for the portfolio, resource, and project overview.

The content pack is a quick download and is designed to help you quickly connect to your Project Online tenant in Office 365. The download includes a variety of data to visually explore and monitor all the key aspects of your PPM deployment surrounding overviews of the portfolio, resource, and project.

Prerequisites

To use the Microsoft Project Online Content Pack, you need the following:
  • Project Online Premium
  • Power BI
  • Power BI Desktop

Settings

Update the URL to your PWA site. From the Home tab:
  1. Edit Queries => Data Source Settings
  2. Click on “Change Source…”
  3. Enter the URL for your PWA site
Refresh the data and update account details. From the Home tab:
  1. Refresh
  2. Click on “Organization account”
  3. Click on “Sign in” and enter credentials





Instructions are pretty straightforward. If you have any questions or need help connect with us by calling 1855-376-0411 or info@projectmadeeasy.com 

Wednesday, April 20, 2016

How to Edit Office 365 Project Porfilio Dashboard



A.      We’re glad to hear that you have the new Office 365 dashboard installed! (If you don’t, go to this link to install it- Its FREE


B.      To access the dashboard after installation, go to settings by navigating to the gear icon, and select Site Contents from the drop down
    


C.      Click on the following Office 365 Dashboard button


D.      From here, you can edit the dashboard. If you’re having difficulties editing, keep reading to find out how.

E.       Here are some tips for editing your dashboard:

1.       Click on the Options tab up in the ribbon

2.       Click on the Sections

3.       Select the dashboard section you wish to edit from the Dashboard Section dropdown, and chose the layout you desire from the Selection Layout options

4.       You can now select the available widgets (numbered 4-6 in the visual) to change what is displayed on the dashboard.
Before








To replace a chart: Click on one of the charts in the ribbon- In this example, we will replace the Project Cost by EPT Pie chart by clicking on it in the ribbon (number 5 above) and selecting another option from the drop down (number 2 below).





After:


Thursday, September 24, 2015

Step by Step:Upgrade Project Server 2013 to Project Server 2016

Upgrade to Project Server 2016

Pre-Upgrade Steps

1. Install SharePoint 2016 and Project Server 2016

2. Create a Web Application

3. Update 2013 environment with latest patches

Upgrade Steps:

1. Copy Project Server and Content database from the 2013 environment

a. ProjectWebApp

b. WSS_Content

** Upgrading to 2016 (Both databases will be merged to one database)

1. Select Manage content databases

Verify the Content database:

2. Restore the new database to 2016 SQL Server

The new database is restored as ProjectWebApp_PME and WSS_Content_PME:


3. Run SharePoint 2016 Powershell as administrator:


4. Mount-SPContentDatabase (WSS_Content_PME):

5. Migrate-SPProjectDatabase:


6. Upgrade Completed Successfully


Friday, February 27, 2015

PWA Navigation Made Easy - New App it helps navigating through PWA pages and connects pages directly

This app is developed by Project Made Easy, Inc. It helps in navigating through PWA pages and connects pages directly for example it connects Manage Delegates and Act As Delegates page to each other. Also it connects Timesheet page to Manage Timesheet. Additionally, this app also hides the Remove Task button of the Timesheet page.

"Manage timesheet" button on Timesheet Page

"Act as Delegate" button on Manage Delegate Page

"Add Delegate" button on Act as Delegate Page


 
 
 
 
Link to download the APP:
https://store.office.com/pwa-navigation-made-easy-WA104379310.aspx?assetid=WA104379310

Friday, February 06, 2015

Project Server 2013: Error while opening Project plan in Project Web Access

Issue Description:

Getting the following error while opening the Project Plan in PWA.
An error occurred while opening your project. Give us a few minutes and try again. If this happens again, contact your administrator.

ULS:

Permission denied: User i:0#.w|pmedev\proj2010 does not have category permission 'SaveProtectedBaseline' on project 5850e0f8-cdf2-4092-9cc3-577102564a24

CalcServiceManager : Communication with the worker failed while opening project guid: 6f771fcd-afad-e411-9420-00155d113d0b System.ServiceModel.FaultException: The server was unable to process the request due to an internal error.   

02/05/2015 21:34:28.48     Microsoft.Office.Project.Server (0x06B8)  0x3900          Project Server                          Project Calculation Service (M)      ai2mx Medium         PWA:, ServiceApp:Project Server Service Application, User:i:0#.w|pmedev\proj2010, PSI: Failed to open project: 6f771fcd-afad-e411-9420-00155d113d0b, in site: b6088326-72bb-4882-b491-133e5eee2d93 Project:6f771fcd-afad-e411-9420-00155d113d0b  0cf2e69c-59f7-303c-4570-94300b0f2499


Cause: The issue occurs due to the value added for the custom field “State” in migrated environment from Project Server 2007.

Resolution:

To avoid the issue on the new project,

1.    Open the Enterprise Custom Fields and Lookup Tables à Click on “State” field

2.    Remove the check box “Choose a value to use as a default when adding new items”

To resolve the issue with the existing projects,

Need to remove the MD_PROP_ID='190873600' value for the projects from the table draft.MSP_PROJ_CUSTOM_FIELD_VALUES.

Note: Open support ticket with Microsoft to remove the values from the table.

Wednesday, February 04, 2015

Project Online: Issue while executing SSIS package for OData delta sync


Issue Description:

Getting the following error while executing the “OData.AssignmentsTimephased” package.

Error Message:

Exception deserializing the package "The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.

ADDITIONAL INFORMATION:

The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.

 (OData AssignmentsTimephased)

 Cause: Issue occurred due to the version conflict of Visual Studio 2010 and SQL server 2012.

Resolution:

Open Project à Report Properties à Change the value from True to False for the field “Run64BitRuntime”, Later execute the package.



Ref: https://msdn.microsoft.com/en-us/library/office/dn794163(v=office.15).aspx

Friday, January 23, 2015

Project Online 2013 - Webpart Error

Issue: New users get web part error in Project Online using Project Server Security Mode

Resolution:
Sign in as PWA Administrator > Click on  Setting button > PWA Settings > Manage User

Double click the user in question > Make sure the user has atleast team member access.