Project for Web App Outline Numbers missing from data tables

[jsimmons25]

It appears that the outline numbers are missing from the Project Task Table. Also was msdyn_wbsid is not avalible either. Is there a way to access these or recreate via some formula? Our project manager would really like to be able to display these on the Power Bi reports.

[echolima201]

Here is how I solved this issue for my purpose.  

I created a pach column: 

TaskPath = PATH('Project Tasks'[Task ID], 'Project Tasks'[msdyn_parenttask])

Then I created a new column for each level. 

Level 1  =

LOOKUPVALUE(

    'Project Tasks'[Task Name],

   'Project Tasks'[Task ID],

    PATHITEM('Project Tasks'[TaskPath], 1)

)

Level 2

LOOKUPVALUE(

    'Project Tasks'[Task Name],

   'Project Tasks'[Task ID],

    PATHITEM('Project Tasks'[TaskPath], 2)

)

And Finally created a hierarchy for each level.  Therefore I can find the parent task herarchy for each one of them. 

[Susan513]

I came across this issue as well  - and have found that the Outline Numbers are labeled as msdyn_displaysequence. However, note that item 1 in your project shows as 2 in the display sequence data. But from what I can tell this is still in the correct order. Not sure why they can't just call it Outline Number and have it match - but glad I finally found this as I was struggling.

[dlandry]

Has anyone found a solution to this problem or found what dynamics table the outline number is in.  Its amazing of all things they leave out the outline numbers.  I guess task order is a thing of the past ugh...

[dlandry]

I created a work around using the displaysequence number but it requires a lot of manipulation using power query to get to the right view.  Works well with the Gantt roadmap view keeps everything in order.  You basically have to do the following:

1. Round the display sequence in my case I did it down to 2 positions
2. Add a custom text field call it Prefix.  If the sequence is less than 10 then "0" else "" or space
3. Change the sequence to a text field
4. Add a custom text field call suffix use this command 
   1. if List.Count(Text.PositionOf([sequence],".",Occurance.All)) = 0 then ".00" else ""
5. You're basically creating a number field that will have a leading zero for anything less than 10 and a trailing .00 for any whole number. 
6. You then Merge Prefix, sequence and Suffix together and then merge the result to the Index Name or Task Name giving the result below.
7. Hopefully Microsoft will resolve this and just add the outline number ugh...ugh.

[PedroS]

Any updates?  I too need to pull the Task Outline Number from Project into Power BI.

[victorthome]

Although I was able to rank the tasks by using the "msdyn_displaysequence" field, I couldn't convert the display sequence code to a Outline Number view.

Anyone has an idea how to convert the display sequence number to a outline number view?

[v-shex-msft]

HI @jsimmons25,

Did these fields exist in your dataset tables? If not, I think you need to add additional data sources in your report to get data and store it in power bi.
Regards,

Xiaoxin Sheng

[jsimmons25]

Hello @v-shex-msft 

I'm using the New Project for Web which as far as I know is using the CDS in msdyn. The outline number field seems to be autopoulated by a calulation when a new task is added. You can see the column on the Grid Display. The screenshot below is an example project I'm using to test. Please let me know of there is anymore information that I can provide.

Kind Regards,

Jon Simmons

[v-shex-msft]

Hi @jsimmons25,

AFAIK, some fields not direct stored in your data table, so you need to check another table or major data tables for these fields. 

Notice: you have a table 'TEST' with 10 fields, 6 fields are direct and stored in the 'TEST' table; others are logic fields that stored in the main table and link with correspond table id.
BTW, you can also contact to product support to confirm if they provide any rest API that allows you to get these hidden/logic fields.

Regards,

Xiaoxin Sheng

[Klaudia]

I do have teh same issue it is critical for PM to be able to sie hirearchy in power bi based on teh outline name from Project for Web tool. Can you please advise what to do or impleement it quickly?

[gvoto]

Hi, have you found a solution to this problem? I also need to display the outline number. Please help!