Forum Discussion

jchapmanICT's avatar
jchapmanICT
New Member
3 years ago
Solved

Using PowerBI with Project for the Web - Reporting on Summary Tasks and associated SubTask progress

Hi All:   Hoping someone can help guide me as a relative noob to both Project for the Web and PowerBI.   I need to be able to report on progress on completion of subtasks for each Summary Task in...
Need Help
  • jchapmanICT's avatar
    jchapmanICT
    3 years ago

    Hey Amit,

    Thanks for the response. I have now realised that the tables and fields pulled in by the PowerBI template for Project on the Web are not complete. Pulling in the full dataset allows me to use a parent task field which effectively gives me a workaround for this. 

     

    Thanks again

     

    J

jchapmanICT's avatar
jchapmanICT
New Member
2 years ago

Hi!

I admit I find the current mix of Microsoft Project versions confusing. We are using Microsoft Project for the Web, not Project Online and not Project Web Access - unless they've now changed the naming convention for these products. Really needs a Microsoft Licensing expert to answer any questions around the differences. 

 

What I do know is when I used the Powerbi Template, not ALL of the Project for the Web tables or fields were included. Looking at the PowerBI Data, you can choose additional tables and fields - so in this screenshot, any tables starting with "msdyn" are additional tables I added in. 

 

 

Not sure where you are in the world but if times match, I'd be happy to have a quick Teams call. I'd not call myself a complete expert though so it might end up feeling like the blind leading the blind... 🙂

 

J

lizmplsms's avatar
lizmplsms
New Member
2 years ago

I'm trying to add that projectlabel in to my data. How do you do that?