Forum Discussion
Power BI and MS Projects - Sub Tasks
I have connected MS Project Desktop to the PWA Server and then to Power BI. The link is wroign fine. However when I inport the data from MS Projects there are only two columns for tasks - ParentTaskName and TaskName, where in MS Project there are upto seven levels of tasks. I have tried using the WBS number to filter the data in PowerBi but to no luck.
I am wanting to have all the sub tasks as seperate columns in Power Bi so that they can be used in Gantt Chart visuals etc...
Any help is appreciated
1 Reply
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- 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
- 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
