VPN Data Visibility on Service

[GCR23]

Hi everyone,
I am trying to connect to a SQL Server accessible only with a VPN.
Now i have some doubts. 

If i choose import mode and then i public the report on service, users can see the data even if they are not connected to the VPN?
And if I choose direct query mode?

The goal is to make the data visible only if users are connected to the VPN, regardless of Import or Direct Query mode.

Someone as faced same problem and have an answer?

Thank You!

G

[GCR23]

Hi @v-zhangti ,
thank you so much!

Now it's clear for me 🙂

[v-zhangti · Accepted solution]

Hi, @GCR23 

If you choose Import mode and publish the report to the Power BI service, users will be able to see the data even if they are not connected to the VPN. This is because the data is imported into the Power BI service and stored there, so users can access it without needing to connect to the VPN.

If you choose Direct Query mode, users will only be able to see the data if they are connected to the VPN. This is because Direct Query mode allows users to query the data source directly, so they need to be able to connect to the VPN to access the data.

To ensure that the data is only visible when users are connected to the VPN, you can set up a Virtual Network (VNet) in Azure and connect your SQL Server to it. Then you can configure your Power BI report to use a Gateway that is also connected to the VNet. This will ensure that users can only access the data when they are connected to the VPN.

Use virtual network (VNet) data gateway and data sources in Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

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