Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
I am trying to get the following information from the Project Online OData feed and struggling to figure out how to get it.
I want to show the Next task that is a milestone for each project as below.
Project -- Task
1 -- Milestone 3
2 -- Milestone 2
3 -- Milestone 5
Is this possible and if so how?
Thanks
Hi @ska1903,
What data do you have? I think you need to get the data from Project Online first. Then maybe a measure could help. Can you share a sample?
Best Regards,
Dale
Hi @v-jiascu-msft,
I am using the Project Online content pack template and I am using the OData feed for the information so all the data is available.
My users have started 6 projects in Project Online with their associated tasks and marked some of them as milestones and now want a (supposedly) simple table showing the project name and what the next task, that is marked as a milestone, is and the date that it is supposed to Finish.
I suppose the fields I would need are;
Projects Table;
Project Name
Project ID -> realtionship to Project ID in Tasks Table
Project Owner Name
Tasks Table;
Task Name
Project ID (As above, linked)
Task is Milestone
Task Finish Date
Regards,
Mark
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 58 | |
| 45 | |
| 42 | |
| 20 | |
| 18 |