Connection few reports (SQL, Excel, Semantic model)

Hello The_Crow 

hello The_Crow 

Thanks for getting back with details

the problem lies with with personal gateway only.

The Personal Mode Gateway does not support combining data from multiple sources when one of those sources is another Power BI report (semantic model). This limitation arises because Personal Mode lacks the ability to manage complex mashups involving both cloud and on-premises data sources.
• When you try to connect a semantic model from another report along with SQL Server and Excel on Teams, the gateway cannot handle this combination due to its restricted functionality

Mixing cloud-based data sources (like Power BI semantic models) with on-premises data sources requires advanced capabilities that are typically supported by the Standard On-Premises Data Gateway, not the Personal Mode Gateway

https://radacad.com/the-power-bi-gateway-all-you-need-to-know

please accept this answer and give kudos if this is helpful