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: Blog, Project Online
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: Blog, How to, Project Online, Reporting
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 

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: Blog
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 

Bulk Publish Enterprise Projects Using Microsoft Project Desktop Client

Posted By Posted by: Peter Williams on April 2, 2019

There is all too often a need to bulk publish all enterprise projects. For example, a project custom field formula, or perhaps a lookup value, has been modified; that change won’t appear in reports correctly until all the projects are published. Performing the bulk publish can be achieved by utilizing a small custom PowerShell script

Read More


Blog Posted In 

Retrieving the Status Manager via OData with Project Online

Posted By Posted by: Ahmed Taee on March 27, 2019

Objectives: To return the status manager information using OData Task tables. Definition: The Status Manager field in Microsoft Project contains the name of the enterprise user who is to receive status updates for the current task from resources submitting timesheets/status updates. By default, the status manager is the user who created the task. The status

Read More


Blog Posted In 

Microsoft Project Online: What licenses do I need?

Posted By Posted by: Dan Stopher on March 8, 2019

There have been many times I’ve been asked about what Project Online license was required for a particular function and struggled to provide a solid answer based on the information available on Microsoft Project Online licenses comparison table here. At a high level, the information on the comparison table is useful. But when faced with

Read More


Blog Posted In Blog Posted In: Blog, Project Online
Blog Posted In 

Create Schedule Template with Resource Utilisation Configured to Resource Engagements

Posted By Posted by: Khurram Jamshed on February 26, 2019

When it comes to resource planning of your project, you can either take a top-down approach that happens at the start of the project. Or a bottom-up with a detailed Resource Plan being created at the project planning phase. Microsoft Project Online as a tool can be utilised to support both approaches: 1. Top-down resource

Read More


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