Forum Discussion

David_G-R's avatar
David_G-R
Frequent Visitor
1 year ago
Solved

Report Template for Planner

He Everyone,   I have successfully borrowed the template for reporting on Project for the Web (P4W) ( Project Power BI Templates ) and adapted it for my use.  I have also followed a tutorial to get...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi David_G-R ,

    Planner does not offer a direct indicator for premium or basic plans. However, you can differentiate between them by examining the schema: premium plans include fields such as Effort or are represented as projectTask in Graph/Dataverse, whereas basic plans do not have these features.
    In Power BI, you can add a calculated column :
    PlanType = IF(ISBLANK([Effort]), "Basic", "Premium")

David_G-R's avatar
David_G-R
Frequent Visitor
1 year ago

Ok, I think this is my last related Question.

URLs are created in PBI using a formula, but it is based on the Project links, which obviously no longer work.  The Project URL is created using:

"project.microsoft.com/?org= "& Text.Middle(#"Dataverse URL",8)&"#/tasktimeline?projectId="&[msdyn_projectid]

The Board URL is created using:

"project.microsoft.com/?org= "& Text.Middle(#"Dataverse URL",8)&"#/taskboard?projectId="&[msdyn_projectid]

 

I can build the URLs for planner using the same method but I am struggling to identify the variable elements of the links.

Premium:

planner.cloud.microsoft/webui/premiumplan/LONGID1/org/LONGID2/view/grid?tid=LONGID3

Basic:

planner.cloud.microsoft/webui/plan/LONGID4/view/grid?tid=LONGID3

 

I know that LONGID1 is the Project ID, and that LONGID3 must be the organisation or environment (because it is the same for all my plans), but I have no idea what LONGID2 or LONGID4 are, or where to find.

 

Your help is much appreciated.