Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Our Power BI reports currently pull data from our SQL databases hosted on an Azure virtual machine. The SQL instance is only accessible within its virtual network or directly from the server itself.
We are presently updating data to two Power BI tenants:
Now, we have a client who wants to host the Power BI reports in their own tenant, referred to as Tenant 3. How can we support Tenant 3 without adding an additional virtual machine to the setup?
Solved! Go to Solution.
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.
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.
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.
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.
Hi @land17301,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi @land17301,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
@rajendraongole1 The SQL database is not Azure-hosted; it is hosted on an Azure virtual machine.
Hi @land17301 - The On-Premises Data Gateway method is the most straightforward and scalable approach for this scenario. It allows Tenant 3 to securely connect to the SQL database hosted on the Azure VM without requiring significant infrastructure changes.
Connect to the SQL Database:
In Tenant 3’s Power BI workspace, create a new data source using the gateway.
Use the database credentials for authentication.
Security Considerations:
Ensure that Tenant 3 has access only to the necessary data and not the entire SQL database.
Use Row-Level Security (RLS) or database views to restrict access.
Proud to be a Super User! | |
Hi @land17301 - you can use the Existing Virtual Network Gateway:The on-premises data gateway in standard mode can be used to securely connect Tenant 3 to your Azure-hosted SQL database.
You can install another instance of the Power BI on-premises gateway in standard mode on an existing server within the virtual network.
Share the Gateway with Tenant 3:In Tenant 3, add the SQL database as a data source to the new or existing gateway in standard mode.
Use Azure AD authentication or other supported SQL authentication methods to allow Tenant 3 to connect securely.
This avoids the need for a personal mode gateway, which is tied to a single user account.
Configure Access:Ensure that the SQL database is accessible through the gateway by granting the required permissions to the users in Tenant 3.
Add the necessary firewall rules in Azure to allow the gateway server to access the SQL database.
Proud to be a Super User! | |
User | Count |
---|---|
47 | |
27 | |
21 | |
19 | |
18 |
User | Count |
---|---|
54 | |
47 | |
22 | |
22 | |
20 |