Forum Discussion
Responsive ResidentProblem to import on premise data onto a lakehouse using a DataflowGen2
Hi alfBI
Thanks for using Microsoft Fabric Community.
As I understand that you are trying to load data from an on premise SQL Server onto a Fabric lakehouse using a Dataflow Gen2.
In scenarios where your data sources are located on-premises, Microsoft provides the On-Premises Data Gateway to securely bridge the gap between your on-premises environment and the cloud. This document will guide you through the process of accessing on-premises data sources within Data Factory for Microsoft Fabric using the On-Premises Data Gateway.
For more details please refer to the below mentioned links:
Install an on-premises data gateway.
How to access on-premises data sources in Data Factory for Microsoft Fabric.
On-premises data gateway considerations for data destinations in Dataflow Gen2.
I hope this information is helpful. Please do let us know if you have any queries.
Helper IIHi there,
we had the same problem and were only able to resolve it by not only allowing *.datawarehouse.pbidedicated.windows.net:1433 on the firewall but more (random?!) IPs.
After allowing *.datawarehouse.pbidedicated.windows.net:1433 was not enough, we opened *:1433 and found that the following IP adresses were also adresseed during a load:
20.38.86.50
51.107.48.217
51.107.48.222
They are not able to be assigned to a FQDN.
After doing so we are now able to load data from onPrem, via StagingLakehouse into the final lakehouse.
v-cboorla-msft : What are these IPs? Please update the documentation since only allowing *.datawarehouse.pbidedicated.windows.net:1433 is definetly not enough.
Thanks
Daniel