Forum Discussion

YashikaAgrawal's avatar
YashikaAgrawal
Icon for Post Patron rankPost Patron
11 months ago
Solved

Power BI Tenant Migration – Gateway VM Setup

Hi Team,   We are migrating Power BI from Infy tenant → TATA tenant.   Current Infrastructure: Virtual Machine in Infy tenant hosting Power BI Gateway. Data sources: Oracle and SQL Server (on s...
  • v-veshwara-msft's avatar
    10 months ago

    Hi YashikaAgrawal ,

    Thanks for posting in Microsoft Fabric Community.

    Thanks GilbertQ for your inputs.

     

    For your setup, the gateway VM requires outbound connectivity on TCP 443 to communicate with the Power BI service, and TCP 5671, 5672, and 9350–9354 are required for Azure Service Bus and Azure Relay messaging.

    For Reference: Adjust communication settings for the on-premises data gateway | Microsoft Learn

     

    Regarding the source and target for firewall/network configuration, your understanding is correct: the source is the gateway VM in the TATA tenant, and the target is the Power BI and Azure endpoints such as *.powerbi.com and *.servicebus.windows.net. It’s recommended to allow outbound access to these FQDNs rather than hardcoding IPs, as endpoints can change over time.

     

    For the Oracle question, if the gateway VM needs to connect to an on-premises Oracle database, you should install the Oracle client on the same VM where the gateway is running. The gateway uses the Oracle client libraries locally to communicate with Oracle, so the client must be present on the VM itself. Ensure the client version is compatible with your database and the gateway.

    Microsoft documentation provides guidance here: Manage your data source - Oracle - Power BI | Microsoft Learn

     

    Hope this helps. Please reach out for further assistance.

    Thank you.