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

Nozama's avatar
Nozama
Helper I
2 years ago

I looked left, right and centre and honestly could not find any task which even had the word "parent" in it - unless there is a clever way to play with the IDs etc. šŸ¤·ā€ā™‚ļø

jchapmanICT's avatar
jchapmanICT
New Member
2 years ago

Hey Nozama,

 

Sorry to hear you're still having problems. It took me a while and I am really no expert so I would hate to describe to you a method which is not as Microsoft intend it to be......

 

My advice to you is to log a ticket with Microsoft. You can do this via your tenancy - https://admin.microsoft.com/AdminPortal/#/support

 

Alternatively I'd be happy to have a quick Teams call to see if I can talk you through this...

 

What I will say is that there is a field entitled "msdyn_parenttask" which you can use as a filter - i.e. "Only show me records where "msdyn_parenttask" is not blank" - then use the "Project Task Name" field to display the Task name etc etc. 

 

If that doesn't work - a Teams call, or log a ticket with Microsoft - they were pretty responsive to my queries.

 

Best wishes (and good luck)

 

John

 

  • MelanieEB's avatar
    MelanieEB
    Frequent Visitor
    2 years ago

    Hi John, I've been struggling with this for the last days and I would be so glad to know how you managed to use the partent task (which is in my dataset) to visualize the tasks acc. to their hirarchy. I tried to make a hirarchy direktly in the data model, but the problem is that sub-subtasks are not allocated correctly.  I.e. a task is only allocated to its direct partent, not its parent parent. 
    Thanks a lot for any hint. Regards Melanie

  • jchapmanICT's avatar
    jchapmanICT
    New Member
    2 years ago

    Hi Melanie:

     

    I wish I could help you. I'm really no expert. I have not actually touched this since April. My recommendation is to log a ticket with Microsoft - they were super helpful with me and pretty responsive. 

     

    J

  • MelanieEB's avatar
    MelanieEB
    Frequent Visitor
    2 years ago

    Hi John,

    thanks for taking the time to reply. I will check with Microsoft directly.

    Seasons Greeting!

    Melanie