Forum Discussion

MikaelDavidsson's avatar
MikaelDavidsson
Frequent Visitor
3 years ago
Solved

OnPremise Gateway, cannot write to lakehouse

Hi,   I am setting up an extraction step in my medallion-arcitechure in Fabric where I want to get data from an on-premise SQL Server. I have installed the on premise datagateway (latest release) a...
Dataflows
Need Help
  • MikaelDavidsson's avatar
    MikaelDavidsson
    3 years ago

    We have now managed to get the data in to the lakehouse. Greate success!

     

    The information that I got from our hosting partner was that traffic going to pbipneu5-northeurope.pbidedicated.windows.net. was blocked. When this blockade was lifted, it started working. 

     

    New rule in firewall:

    Protocol: TCP
    Endpoint: pbipneu5-northeurope.pbidedicated.windows.net
    Port: 1433

     

    pbipneu5-northeurope depends on what region you have chosen.

     

    Hope this helps.

     

    //Mikael

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Mikael,

Thanks for sharing your approach! So am I right in assuming i would have to do these changes on the machine where the Data Gateway is installed?

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
2 years ago

No, only in the firewall settings, wherever that happens to be running on your network.