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
    2 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

miguel's avatar
miguel
Icon for Community Admin rankCommunity Admin
3 years ago

I'm not entirely sure we can reach a conclusion with the information provided, but definitely using the latest gateway and making sure that its not a network firewall issue are on top of my mind for things to consider given the information.

 

I'd highly recommend reaching out to our support team so they can take a closer look at your scenario and try to troubleshoot.

https://support.fabric.microsoft.com/support 

  • henrikj's avatar
    henrikj
    Icon for Advocate II rankAdvocate II
    3 years ago

    I get the same message, although I want to write to a WH.

     

    The GW connection is working for Power BI

    Data is present in the staging lakehouse

    I've tried to wrtite data both with and without staging. 

    We use Finnish_Swedish_CI_AS as collation and I've tried using both English locale and Swedish locale for the DF.