Forum Discussion

ScottPowellECU's avatar
ScottPowellECU
Icon for Advocate II rankAdvocate II
3 years ago

Microsoft - new gateway server network diagram?

Hi folks, Microsoft had published a network diagram for how the gateway servers worked in Power BI ( https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-indepth )

 

From my understanding this doesn't apply to Fabric - it seems that the gateway server needs to be able to talk directly to the Power BI aka Fabric service on port 1433 to load data to a warehouse or lakehouse. I'm understanding this due to the fact that loads are failing if port 1433 is blocked from the gateway server.

 

Just wanted Microsoft to be aware that this diagram needs updated. Are there other changes than a new direct connection between the gateway servers and the SQL endpoints?

 

Thanks,

Scott

General Question

9 Replies

  • motoray's avatar
    motoray
    Icon for Advocate V rankAdvocate V
    3 years ago

    This is new and I don't really understand why. I've been able to get data loaded into staging warehouses and lakehouses so it doesn't make much sense to me that the step of loading data to the actual warehouse needs to suddenly connect to the gateway servers on that port.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This should be addressed with the July release of the gateway. Can you update and try again?

    Also, I can confirm that this does apply to Fabric - we will update the image, good catch on that.

  • AnthonyGenovese's avatar
    AnthonyGenovese
    Icon for Resolver III rankResolver III
    3 years ago

    It looks like the new July 2023 Gateway server addresses a lot of these issues.

    • motoray's avatar
      motoray
      Icon for Advocate V rankAdvocate V
      3 years ago

      Oh man, I hope you're right. I've had really spotty "success" trying to get onprem data into Fabric so far and am feeling like maybe it's time to set this aside until it matures a bit more.

      • AnthonyGenovese's avatar
        AnthonyGenovese
        Icon for Resolver III rankResolver III
        3 years ago

        I was in the exact same boat. Bashing my head with issue after issue. 3 new errors in the past 24 hours. But then I just refreshed a dataflow today to get a baseline, and it worked. Only thing that changed from previous attempts was an updated gateway.  Fingers crossed for you.