Show recently modified items from 21 lists across 21 subsites in Homepage - SharePoint Online

[Kumar902402]

Hi All,

I need to show the 5 recently modified list items, across 21 sites and 21 lists in the same site collection in SharePoint online.

I need to only show the list item based on certain choice field column value. (Eg: Selected choice is red across all 21 lists)

I tried using Highlighted content webpart, however it shows only document libraries.

Any technical advice, if it can be done using powerBI to show the top 5 list items would be helpful. Thanks.