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

[agungsantoso]

Hello!

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.

Regards,

Agung Santoso

[v-eachen-msft]

Hi @agungsantoso ，

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

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

[agungsantoso]

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.