Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ScottPowell
Regular Visitor

On-prem gateway firewall rules?

Hi, we're hitting issues trying to load data from an on-prem SQL server database to Fabric. It appears that our on-prem gateway servers need to be able to talk to the SQL endpoints, which they currently can't (blocked by firewall).

 

Is there clear documentation on exactly what I need to request to our networking team? Not looking forward to this and want to make sure I get this right the first time.

 

Thanks!

Scott

1 ACCEPTED SOLUTION
bcdobbs
Super User
Super User

Hi @ScottPowell ,

Had exactly the same issue.

I found most of confirmation in Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn

 

We've just added *.datawarehouse.pbidedicated.windows.net and allowed communication on 1433.

 

Having pinged it it also seemed to redirect to *.uksouth.cloudapp.azure.com so I asked IT to add that at the same time to avoid messing them around although don't think that's strictly needed.


It is however now fully working.

 

Ben



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

6 REPLIES 6
SidJay
Microsoft Employee
Microsoft Employee

In addition to setting a firewall rule, please upgrade to the latest Gateway (version 3000.178.9 released on June 15th). That should help address at least one class of errors involving output destinations and/or queries that depend on other staged queries.

 

Thanks.

suidino2
Frequent Visitor

The dataflow gen 2 working with On-Prem is too troublesome. I think they need to focus on the context of on-Prem. Other than On-prem, it is nice functioning. 

@suidino2 I couldn't agree more. I guess it makes sense to start with capabilities that stay in the Microsoft cloud - but then you're only serving customers who honestly already have their stuff in the cloud, and fabric makes potentially less sense.

 

I have dreams of nightly copying our 1.5 TB data warehouse into Fabric, but so far haven't been able to move a single byte of data from on-prem up. And I've got a gateway cluster with 3 machines in it - but it's going to have to run orders of magnitude faster for this to work.

 

The one thing that gives me hope is that if I look at the COPY utility documentation, it seems completely doable - and Microsoft has confirmed they are going to have COPY functionality working via on-prem gateway before GA. Can't wait for the day!

 

Scott

bcdobbs
Super User
Super User

Hi @ScottPowell ,

Had exactly the same issue.

I found most of confirmation in Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn

 

We've just added *.datawarehouse.pbidedicated.windows.net and allowed communication on 1433.

 

Having pinged it it also seemed to redirect to *.uksouth.cloudapp.azure.com so I asked IT to add that at the same time to avoid messing them around although don't think that's strictly needed.


It is however now fully working.

 

Ben



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Hi Ben - thank you very much for the info. I didn't see anything that specifically mentioned *.datawarehouse.pbidedicated.windows.net in the link you referenced - do we know that's the "final" URL? Or did you infer that based on the connection string?

 

In any case, I really appreciate the help, now I'll see how far I can get with the network / firewall team.

 

Thanks!

Scott

Yes just inferred from connection string but I don't see why that would change between now and GA. Only my guess though!



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
Sept Fabric Carousel

Fabric Monthly Update - September 2024

Check out the September 2024 Fabric update to learn about new features.

Expanding the Data Factory Forums

New forum boards available in Data Factory

Ask questions in Apache Airflow Job and Mirroring.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors