Power BI
2 TopicsTask with multiple resources showing as multiple rows in Power BI table; instead of just the one row
Question please. I have Project on the Web schedule with many tasks, and some have multiple resources assigned. When I pull the tasks into a table in Power BI report I am getting a row for each task with the resource, instead of the task listing both resources on one row. So if there are 4 resources, the task shows 4 times, once per resource. The tables tasks and resources have a relationship, so is this the way it is supposed to work? How can I just show a list of unique tasks and all the resources assigned in one row per task? Grouping of some sort? So 1 task with 4 resources, shows as 1 task with 4 resources all in one row. Thank youSolved42Views0likes3CommentsPower BI and MS Project for Web data source connectivity fails
Hello Everyone, I've installed "Microsoft Project Web App" Power BI app in Power BI service (cloud app). Link for the same is:MS Project for Web App There are no issues with this Power BI app installation but, when I try to connect it with the PWA (OData) data source I get an error message.Following are the error messages received: 1. "The column 'CostType' of the table wasn't found" 2. "The column 'ProjectDepartments' of the table wasn't found" Does anyone knows how to solve this issue? Thanks & Regards, Rohan1.3KViews0likes2Comments