Blog

Synchronising PWA schedules to the appropriate SharePoint Task List when dealing with multiple Task Lists

Posted By Posted by: Eremo Zanye on July 15, 2019

Background You may be required to develop a project site with the need for custom lists to be added to existing default lists – Risk, Issues, etc. If the custom list is using the out-of-the-box task type, then a problem may arise. Before discussing the issue, I’ll briefly explain the feature of synchronising a project

Read More


Blog Posted In Blog Posted In: Blog, How to, SharePoint
Blog Posted In 

How to close a Project (not task) to timesheets

Posted By Posted by: Dan Stopher on July 2, 2019

In the PPM community it is fairly well understood that we can use the “Lock Tasks to Timesheets” function to stop a timesheet user being able to log time against those tasks in a timesheet. However, I recently had the request where the client was not logging effort against tasks but rather projects and wanted

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

Updating a Project Site Template

Posted By Posted by: Cheston Hsu on June 26, 2019

The Project Site Template dictates the look, feel as well as the contents of a project site when created. Hence, it is extremely important that any changes that are made on the template are changes that you would like to see on your FUTURE project site. The below is a guide on how to update

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

How to get a unique Project Number between different Enterprise Project Types

Posted By Posted by: Ahmed Taee on June 14, 2019

I was faced with a requirement to produce unique project numbers in sequence despite of the project EPT type. Project numbers such as: PPMxxxxxx (x are consecutive numbers starting from 000001). Requirements Project Server 2016 or Project Online. SharePoint Designer 2013. So this was the approach I took in producing the unique project numbers:  Create

Read More


Blog Posted In Blog Posted In: Uncategorized
Blog Posted In 

What does the Remove Task feature do on timesheets?

Posted By Posted by: Cheston Hsu on June 5, 2019

Users when seeing this button may use it to remove a task from their timesheet without understanding what it truly does. The intent of this button is for user, to reject a task that has been assigned to them. Once the rejection has been approved by the project manager, the user is no longer assigned

Read More


Blog Posted In Blog Posted In: Uncategorized
Blog Posted In 

Using PowerBI REST API to overcome frustrating oData URL filter limitation

Posted By Posted by: Peter Williams on May 28, 2019

The Problem I had a need to create report that consumed the following data sources: Project Online timesheet data SharePoint Online list info On-Premise SharePoint list info Zendesk ticket data I have a reasonable amount of experience using PowerBI to query and consolidate this information. My desire was to have a report that used essentially

Read More


Blog Posted In Blog Posted In: Uncategorized
Blog Posted In 

Why has a task disappeared from my Timesheet?

Posted By Posted by: Cheston Hsu on May 17, 2019

Timesheets are important for projects as they are often the source-of-truth for effort consumed. They form the basis of many project cost reports. This blog aims to explain the somewhat mysterious behaviour of Microsoft Project Online (and also Project Server 2010, 2013, 2016, 2019) timesheet module that timesheet users and managers interact with. One of

Read More


Blog Posted In Blog Posted In: Uncategorized
Blog Posted In 

The importance of data “freshness” in Power Bi

Posted By Posted by: Cheston Hsu on May 8, 2019

To ensure that a business can make accurate and sound decisions, the “freshness” of information and data available to them is critical. Having “old” or “stale” information and data can lead to poor or wrong decisions that could devastate a business. Ideally, keeping data “fresh” should be an automated process to ensure that whenever a

Read More


Blog Posted In Blog Posted In: Uncategorized
Blog Posted In 

Update Project Online Resource Custom Field with Lookup Value Using PowerShell

Posted By Posted by: Ahmed Taee on April 29, 2019

Preface There are plenty of useful blogs that discuss how to update custom fields using PowerShell (or .Net) in Project Online/Project Server 2013 or later, but most don’t discuss how to update custom fields which utilize a lookup table. As it turns out, this is rather tricky. Objective To update a custom field that utilizes

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

Relationship in Power Bi

Posted By Posted by: Cheston Hsu on April 18, 2019

What is a relationship and how does it affect Power Bi Relationships in both life and Power Bi can be complicated. Relationships in Power Bi are necessary as they form a bond between different tables to accurately correlate and display data. There are various cardinalities used in these relationships and different types of filters that

Read More


Blog Posted In Blog Posted In: Blog
Blog Posted In