topic Communication settings in firewall for dataflowgen2 in Dataflow

Communication settings in firewall for dataflowgen2

Dinesh09 — Sun, 11 Feb 2024 12:27:43 GMT

In windows OS how to check if the outbound rules have been enabled in the firewall of the on-prem gateway server. This is to fetch data from SQL server via on-prem gateway

Re: Communication settings in firewall for dataflowgen2

v-cboorla-msft — Mon, 12 Feb 2024 06:15:21 GMT

Hi Dinesh09

Thanks for using Microsoft Fabric Community.

As I understand that you want to check in Windows OS, whether the outbound rules are enabled in the firewall of your on-prem gateway server for fetching data from an SQL server via Microsoft Fabric.

You can use On-premises Data Gateway app to get the necessary outbound firewall rules.

While the On-premises Data Gateway app itself doesn't directly modify firewall rules, it can be helpful in checking and diagnosing whether the necessary outbound rules are enabled.

Please refer to the below mentioned documents for more details.

Document1 : Use the on-premises data gateway app

Document2 : Network ports test

I hope this information helps. Please do let us know if you have any further questions.

Thanks.

Re: Communication settings in firewall for dataflowgen2

Dinesh09 — Mon, 12 Feb 2024 16:40:58 GMT

Even though *.datawarehouse.pbidedicated.windows.net is enabled in outbound rules of firewall I am not able to see in gateway port results. Are you able to see in your gateway port results? If yes please share your screenshot

Re: Communication settings in firewall for dataflowgen2

R1k91 — Tue, 20 Feb 2024 11:45:34 GMT

gateway port results just checks if your firewall allows communication between gateway machine and azure in order to make it work.

your "custom rules" to data sources is not available there.

Re: Communication settings in firewall for dataflowgen2

v-cboorla-msft — Mon, 04 Mar 2024 12:28:13 GMT

Hi Dinesh09

Apologies for the delay in response from my end. Inorder to help you better, it requires a deeper investigation from our engineering team about your workspace.

Please go ahead and raise a support ticket to reach our support team: support-ticket

Please provide the ticket number here as we can keep an eye on it.

Thanks.