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

MikaelDavidsson's avatar
MikaelDavidsson
Frequent Visitor
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.