Power BI and MS Projects - Sub Tasks

Hello PM2024 

When exporting data from Microsoft Project, the default export does not automatically create separate columns for each subtask level. Instead, it typically includes fields like ParentTaskName and TaskName, which do not directly translate into a hierarchical structure suitable for most Gantt Chart visuals in Power BI.


you need to restructure your data to reflect the hierarchical task levels from Microsoft Project.

I avent done this personally , but worth trying 

1. Split the Outline_Number column in Power Query into separate columns for each level in the hierarchy. This will create distinct columns for each subtask level
2. Create a parent-child relationship in your data. This is the most flexible way to include hierarchy. Add a column where each child task refers to its parent task. If there's no parent specified, the item will be displayed at the highest level

https://community.fabric.microsoft.com/t5/Desktop/Use-WBS-field-to-create-parent-child-hierarchy-within-Power-BI/td-p/3712236

https://community.fabric.microsoft.com/t5/Desktop/Project-Hierarchy-from-Power-Bi-Goals-to-Gantt-223-chart/td-p/2858896

Thanks