The updated Projects Power BI app for Business Central gives project managers a better overview of the profitability of their projects. Plus, partners and customers can build on the open-source model and reports to make their reporting on projects their own.

As part of getting the source code ready for open source, we also made changes to the semantic model and to the reports.

The following are key changes to the semantic model:

Added dynamic dimension support (review the Dimension Sets table).
Added Project Statistics measures in the Project Ledger and Project Planning Lines tables.
Updated reconciliations so that the numbers match the values on the Project Statistics page.
Added a new Type table to allow for type-specific reporting.
Removed Starting and Ending Date tables.
Task-related Starting and Ending Dates are now columns in the Tasks table.

The following are key changes to reports:

Replaced existing measures with Project Statistic measures.
Changed the Project Performance to Budget page so that it now compares Budget to Usage. Previously, it compared Budget to Invoiced.
Added new Type table fields to improve the Project Invoiced Sales by Type page.
Added a Billable to Invoiced % gauge.
Added new Type table fields to improve the Project Invoiced Sales by Customer page.
Aligned report visuals with the Project Invoiced Sales by Type report.
Changed the Gantt chart style on the Project Timeline page to use square bars, so that it aligns with changes to reports in manufacturing.