Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jsimmons25
Frequent Visitor

Project for Web App Outline Numbers missing from data tables

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.

11 REPLIES 11
echolima201
Frequent Visitor

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
Frequent Visitor

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.

Susan513_0-1681478757598.png

 

dlandry
Helper I
Helper I

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...

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.

dlandry_0-1652383546476.png

 

PedroS
New Member

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

victorthome
New Member

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
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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

 

powerbi_the_new_project_for_web - Copy.png

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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?

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.