I need to create a report to view tasks updates that are pending for approval

Hello,

I need to create a report using Power BI or Excel to show the pending approvals of task updates, however, the OData connection does not provide any table that can provide this information, it shows only the approved and published tasks updates (hours)

Actually, we need this to be able to follow up on whatever pending actions with any project owner or status manager.

appreciate your help and guidance for how to retrieve such information.