I'm asked to create a summary report from the reports published by various teams, some sort of report of the reports because some C-Level doesn't want to see all the reports but certain parts of it.

Actually, I understand the request but I find it a bit tricky to implement in Power BI.

I'm thinking of the following three solutions:

Workspace Apps (or Org Apps)

Main problem with this is the reports are in different workspaces. I have to create a copy of each report in a specific workspace and I don't know how to keep the original and the copy in sync. (maybe deployment pipelines?)

Dashboards

I can pin visuals to a dashboard but I'm not a big fan of this object. It looks outdated and isn't very flexible/customizable.

Having reports in different workspaces is creating the same issue as in Apps.

Connecting to the Semantic Model of each report

This is the option I'm looking at. I will create a new semantic model that reads the measure table from different reports and I will revisualize them. For 3 reports it works well but I'm not sure if I will hit performance issues with more semantic models (let's say 10+).

I'd love to hear from you if you came across a similar situation.

Note: I have access to Premium Capacity (Fabric features are blocked)