Forum Discussion
Report Template for Planner
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")
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.
Did you ever figure out the Planner links? Trying to find a way to update the links in the P4W PBI template to go to the new Planner link, but have been unsuccessful so far.
Yes I did, I amended the custom column to the following:
= Table.AddColumn(#"Previous step name", "Project URL", each "https://planner.cloud.microsoft/webui/premiumplan/"& [msdyn_projectid] &"/org/LONGID2/view/grid?tid=LONGID3")
Where LONGID2 is the Organisational number, I'm not sure what LONGID3 is but it is constistantly the same in my plans, you can extract both of these IDs from the URL for any of your premium plans. the plan ID which is variable, is captured by the [msdyn_projectid] field.
I hope that helps you.