Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have a SQL Server on a VM (IAAS) inside a VNET in my organization. Access to the datasource from the outside world needs a VPN connection into the VNET first, then can connect to the SQL Server database using the data source's credentials.
My question, after reading about the Power BI Gateway (Enterprise), is that if i create content that uses this data source, does the gateway remove the need to VPN into the VNET? Or this is still required?
I am using Power BI pro and so are the clients of this Power BI dashboard.
Thanks.
Solved! Go to Solution.
All that matters is that the enterprise gateway has access to the data source.
The end user in a browser, using a report that makes use of the enterprise gateway, does not need to have network access to the data source or that network. This is possible because the Power BI service uses Azure Service Bus to send queries and credentials to the gateway. Then the gateway does the physical connection to the data source. In the case of SQL Server, we just use the credential that was hard coded in the data source, when configured. For analysis services, we pass the email address you logged into power bi. This is used as the EffectiveUserName property of the connection to AS.
In either case, the end user doesn't need network connectivity to the actual data source.
All that matters is that the enterprise gateway has access to the data source.
The end user in a browser, using a report that makes use of the enterprise gateway, does not need to have network access to the data source or that network. This is possible because the Power BI service uses Azure Service Bus to send queries and credentials to the gateway. Then the gateway does the physical connection to the data source. In the case of SQL Server, we just use the credential that was hard coded in the data source, when configured. For analysis services, we pass the email address you logged into power bi. This is used as the EffectiveUserName property of the connection to AS.
In either case, the end user doesn't need network connectivity to the actual data source.
I have a Power BI Service pointing to an on-premise SQL Server Database table that belongs to a secured VLAN where I need VPN credentials to access. If I setup a scheduled refresh of the report in Power BI Service, and I'm in the office connected to the corporate network, everything runs smoothly. As soon as I leave the office, and my surface is not connected to the VPN, the Schedule Refresh crashes...
Am I missing something?
I'm using my windows credentials hard-coded in the data source.
Thanks for you time!
VNET is the extension of your network in the cloud. So I am assuming you do not need to VPN to the VM when you are within your network. If this is the case, enterprise gateway will remove the need for VPN.
--nikil
Check out Chicagoland Power BI User Group
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
30 | |
18 | |
12 | |
8 |
User | Count |
---|---|
50 | |
36 | |
30 | |
15 | |
12 |