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 

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 

Create a Word document automatically from Project Data using Flow

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

Microsoft Project Online solution enables the storage of project data in a central repository to increase visibility across the organisation. Reporting on that data can be generated using different tools available such as SSRS, Power BI etc.  An example of the reporting output is a nicely formatted Word document with the most up-to-date project status

Read More


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

How to Print a Program/Portfolio View of Projects

Posted By Posted by: Peter Williams on February 6, 2019

When it comes to program and portfolio management of projects, a Gantt chart view is often desirable with milestone and other key dates superimposed. Within the Microsoft suite of products and features, there are several options to produce Gantt charts of your portfolio. However, what options are there for printing out Gantt charts when using

Read More


Blog Posted In Blog Posted In: Blog, How to, 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 

How to convert an Excel formula from SSRS report

Posted By Posted by: Ahmed Taee on October 25, 2016

In your report, create a field that will be a formula field when the report is exported to Excel. In the example below, the cell underneath Results column header will be the summation of First Value plus Second Value.   The expression content will be “=C3+D3”   Run the report and export it to Excel   To convert

Read More


Blog Posted In Blog Posted In: Blog, How to, Reporting, Uncategorized
Blog Posted In 

To integrate, or not to integrate data (in Project Server or Project Online)

Posted By Posted by: EPM Partners on September 29, 2016

When is it a good idea to follow through data integration ideas with Project Server or with Project Online? Almost every client I’ve worked with brings this topic up after adopting the tool set. Is this a good idea? It depends. In this blog, I will share my rule of thumb to help you make

Read More


Blog Posted In 

SSRS 2012 Report Issue – Page refreshes and parameters changes back to default in Chrome browser

Posted By Posted by: Ahmed Taee on August 3, 2016

Issue In Chrome browser, when you change the parameters and click “Apply” after executing an SSRS 2012 report, the parameters reverts back to default. This issue, however, does not occur in Internet Explorer browser. Solution Log on to the client’s server as an admin user Run IIS (Internet Information Service) software Right Click on the

Read More


Blog Posted In 

Project Online and Project Server – Reporting Enhancements

Posted By Posted by: Khurram Jamshed on December 10, 2015

Reporting is an integral factor to any successful PPM deployment, and Microsoft is continuously investing in reporting capabilities, making it bigger and better. In this blog post, I will bring together few recent updates to reporting options that can help get the best out of Project (online and on-premises) data, and will share links to

Read More


Blog Posted In