Get Report properties automatically from a Workspace into a Sharepoint Communication Site

Hi, Anonymous 

Based on your requirement provided, I think you can consider achieve the similiar requirement by creating an "Overview" page within one of your Power BI report that contains all the navigation buttons that can help redirect to all the pages that you wish to have in the Overview, once the "Overview" page is created, then you can try just embed this single page into your SharePoint site to achieve your requirement.

Regarding the navigation buttons creating guidance, you can refer to this official document link:

Create page and bookmark navigators - Power BI | Microsoft Learn

Regarding the Secure embed Power BI pages into SharePoint page, you can refer to this official document link:

Embed a report in a secure portal or website - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly