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 

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 

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 

Microsoft Power BI taking the next step in Local Government Reporting

Posted By Posted by: EPM Partners on February 25, 2019

Microsoft Power BI paved the way to automated reporting & in-house visual dashboards for local government. Resulting in decreased reporting preparation time, and more focus on analysis and collaboration leading to increased staff productivity. Read all about this here: https://news.microsoft.com/en-au/2019/02/11/taking-best-in-class-local-government-reporting-to-the-next-level-using-power-bi/


Blog Posted In Blog Posted In: Blog, News, Reporting
Blog Posted In 

What is Power BI?

Posted By Posted by: EPM Partners on November 16, 2018

Do you currently have a list of SharePoint sites, OData feeds, excel sheets, websites, CRMs and databases that all have different types of important data? Wouldn’t it be nice if you could combine them all into one central location and fuse the different data sets to provide meaningful information? This is Power Bi! Not only

Read More


Blog Posted In Blog Posted In: Blog, Reporting
Blog Posted In 

Calculate Resource Utilisation from Resource Engagements Explained

Posted By Posted by: Dan Stopher on April 20, 2018

Since the introduction of Engagements to Microsoft Project Online we have had the below option in MS Project under Project -> Project Information But what exactly does this setting do? Resource Centre In the case of the Resource Centre -> Capacity Planning -> Capacity and Engagements heatmap view, this setting has no effect! This view shows

Read More


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

Retrieving Custom List Data from All Project Online Sites with Power BI

Posted By Posted by: Peter Williams on January 22, 2018

Background Microsoft Project Online is a great platform to manage a programme/portfolio of projects. Project Online is an app that leverages SharePoint Online; it is effectively a very complex “app” for SharePoint Online. Project Online encourages project collaboration via the use of a dedicated SharePoint site for each project. Typically, you can expect to find

Read More


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

Power BI Bookmarks

Posted By Posted by: EPM Partners on December 8, 2017

For those who are looking for presentation tools beyond PowerPoint, look at Microsoft PowerBI. Power BI is a new and well-known tool in the Microsoft ecosystem. Though it has only been around for three years, it is already a leader in the BI & Analytics market. Prior to PowerBI, the market had been dominated by tools like

Read More


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