Power BI Multi-Tenancy

Hi land17301,

Thank you for reaching out to the Microsoft Fabric community Forum.

Yes, it is possible to support Tenant 3 in Microsoft Fabric without adding an additional virtual machine. Please go through the below following steps to solve your issue.

• Create a new workspace in Microsoft Fabric. This workspace will be used to manage data and reports for Tenant 3.
• Ingest data from your SQL databases into Fabric. You can use Dataflows or Data Engineering experiences like Spark or Dataflow Gen 2 to transform and load data into a Lakehouse.
• When you create a lake house in fabric, a power bi semantic model and a sql endpoint are automatically created. Use the semantic model for power bi reporting and the sql endpoint for direct queries.
• Use Power BI Embedded to embed your reports into Tenant 3's web application. This allows Tenant 3 to access the reports through their own application.
• Ensure that data isolation and security measures are in place. Use service principal profiles to manage organizational content and achieve tenant isolation.
• Depending on whether Tenant 3 users are internal or external, configure the appropriate authentication method. For internal users, use Microsoft Entra ID formerly Azure Active Directory for external users, use embedding identities Microsoft Entra service principal or master user account.

Please go through the below documentation links for better understanding.

Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn

Power BI implementation planning: Data gateways - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you.