Forum Discussion
Error loading data from on prem SQL server to Fabric Lakehouse with Dataflows Gen2
miguel I am trying to load a table with Dataflows Gen 2 from an on premise SQL server to a Lakehouse in Fabric with load to destination. No luck so far. I keep getting this error: There was a proble...
The solution was in our case that is was not enough to open up port 1433 en whitelist the right addresses *.datawarehouse.pbidedicated.windows.net and the more usecase specific *.northeurope.cloudapp.azure.com in the Fortinet firewall but to open up SQL access in the firewall from our VM (where the gateway is) to the Fortinet maintained internet service 'Azure'.
marcoG
Advocate III
Advocate IIIHi Anonymous ,
I found this article:
https://learn.microsoft.com/en-us/fabric/data-factory/gateway-considerations-output-destinations
And this fabric blog article:
https://blog.fabric.microsoft.com/it-it/blog/data-factory-spotlight-dataflows-gen2?ft=All:
So i will attend for next release to disable staging area so I don’t need to use 1433 port.
I think this will work for me.
Bye