Power BI Dataset and VNET-Gateway

[snboris]

Hi .. some problem.

In PowerBi service i have create da VNET-Datagateway and it works well with some reports.

I create a new Report/Dataset in PowerBi Desktop with a local SQL-Server Database as source.

Works fine an I publish this to PowerBi service.

Now i will change the settings for Dataset so it can access the database behind the VNET-Datagateway.

But when I open Dataset->Settings->Gateway and Cloud Connections,

I see the switch for 'Use an On-premises or VNet data gateway' is set to off and greyed out.

Below is the Message:

You don't have any data gateways.

We didn't find any suitable data gateways to connect to the data sources that this dataset uses. Either install an on-premises data gateway and add the data sources that this dataset uses to it, or install a data gateway in personal mode to connect this dataset to its data sources.

Am I missing certain rights to use the VNET data gateway for new reports or what is the reason?

[v-zhangti]

Hi, @snboris 

Please refer to the following links in the hopes of helping you.
Use virtual network (VNet) data gateway and data sources in Power BI | Microsoft Learn

What is a virtual network (VNet) data gateway (Preview) | Microsoft Learn

Virtual network (VNet) data gateway FAQs | Microsoft Learn

Solved: Scheduled Refresh - Azure SQL Database behind VNET - Microsoft Fabric Community

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.