Gateway Connectivity Error

Hi wojciech ,

I think you can do these steps below:

1. Verify that all necessary IP ranges used by Dataflow Gen2 service are allowed in your network firewall settings. Microsoft provides a list of IP addresses that Power BI uses, which may differ slightly for Dataflow Gen2.

2. Dataflow Gen2 might require the use of the TDS protocol (TCP over port 1433) to read data from the staging Lakehouse before copying it to the desired data destination. Ensure that this port is open and accessible.

3. Sometimes, more detailed error messages can be found in the Power BI Service logs. Go to Settings > Manage Gateways > VNET Gateway Logs and look for any errors or warnings related to the dataflow refresh.

4. You can also look at this two documents:

Dataflow gen2 with Virtual Machine Gateway refresh... - Microsoft Fabric Community

On-premises data gateway considerations for data destinations in Dataflow Gen2 - Microsoft Fabric | Microsoft Learn

Best Regards

Yilong Zhou

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