Showing results for 
Search instead for 
Did you mean: 
New Member

Get Microsoft Project Unapproved Task and Unpublished Approved Task from Power BI



I am trying to create a report in Power BI about how many tasks not yet approved by the status manager and how many tasks already approved but not yet published. Usually, I use OData to get data from Microsoft Project, but I can't find a table or field related to task approval. Does anyone know how to solve this problem?


Thanks and sorry for my bad English.



Agung Santoso

Community Support
Community Support

Hi @agungsantoso ,


1. Your URL may be incorrect, you could check it.

2. Your expected table may be a collection of multiple tables.



Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Hi @v-eachen-msft,


Thanks for your reply, my OData connection is working well. I can get data from it. My problem is I can't find table/entities that has data about unapproved tasks or approved tasks but not yet published. I already find it in tasks, assignments table but it seems no data about it.

Helpful resources



We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors