March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
Here is how I solved this issue for my purpose.
I created a pach column:
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.
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:
Any updates? I too need to pull the Task Outline Number from Project into Power BI.
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?
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
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
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
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
167 | |
148 | |
92 | |
72 | |
58 |