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