APPLIES TO: Generally available in Business Central 2025 release wave 1 (version 26.x).
The Project Timeline report shows task dates and durations based on project planning lines. A task's starting date is its earliest planning date, and its ending date is its latest planning date. The report includes the project number, task number, and description.
[Screenshot of the Project Timeline Power BI Report]
Use the report
Project managers and team members use the report to effectively monitor and plan project timelines.
As a manager, you can use the report to monitor the duration of individual tasks within a project. Review the dates to identify potential scheduling issues and decide whether to adjust timelines or resource allocations. The report doesn't calculate a critical path or task dependencies.
For team members involved in project execution, the report serves as a tool for understanding their task timelines. By referring to this report, staff can prioritize their tasks, collaborate with other team members effectively, and meet project deadlines.
Key performance indicators (KPIs)
The report includes the following calculated date columns and duration measures:
- Project Task Starting Date
- Project Task Ending Date
- Project Task Duration Days
- Project Task Duration Weeks
Click on the link for a KPI to learn more about what it means, how it is calculated, and what data was used in the calculations.
Tip
You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.
Data used in the report
The report uses data from the following tables in Business Central:
- Job
- Job Task
- Job Planning Line
Try the report
Try the report here: Project Timeline
Tip
If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.
Related information
Track your business KPIs with Power BI goals
Power BI Projects app
Built-in Projects reports
Project management analytics overview
Project management overview