Forum Discussion

Charu's avatar
Charu
Post Patron
8 years ago

Oracle Database On Premises Gateway connection error

Hi Everyone,   In power bi service I've tried to connect Oracle database and SQL Server database I'm getting the below error  Followed the Microsoft documents and installed gateway as well a...
Need Help
Charu's avatar
Charu
Post Patron
8 years ago

Hi Anonymous

 

below is the detailed error message when I tried to connect oracle database.

  • Charu's avatar
    Charu
    Post Patron
    8 years ago

    Hi Anonymous

     

    Followed the instructions given by you, In UDL test I gave oracle credentials and the Connection status is a success but unable to do the same in power bi service... Wonder

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Charu,

       

      Can you provide the local gateway log? 

       

      In addition, have you check your port settings and firewall white list?

      On-premises data gateway

       

      Spoiler

      Ports

      The gateway creates an outbound connection to Azure Service Bus. It communicates on outbound ports: TCP 443 (default), 5671, 5672, 9350 thru 9354. The gateway does not require inbound ports. Learn more

      It is recommended that you whitelist the IP addresses, for your data region, in your firewall. You can download the Microsoft Azure Datacenter IP list. This list is updated weekly. The gateway will communicate with Azure Service Bus using the IP address along with the fully qualified domain name (FQDN). If you are forcing the gateway to communicate using HTTPS it will strictly use FQDN only, and no communication will happen using IP addresses.

      Note

      The IP Addresses listed in the Azure Datacenter IP list are in CIDR notation. For example, 10.0.0.0/24 does not mean 10.0.0.0 thru 10.0.0.24. Learn more about the CIDR notation.

      Here is a listing of the fully qualified domain names used by the gateway.

      Domain names Outbound ports Description
      *.download.microsoft.com 80 HTTP used to download the installer.
      *.powerbi.com 443 HTTPS
      *.analysis.windows.net 443 HTTPS
      *.login.windows.net 443 HTTPS
      *.servicebus.windows.net 5671-5672 Advanced Message Queuing Protocol (AMQP)
      *.servicebus.windows.net 443, 9350-9354 Listeners on Service Bus Relay over TCP (requires 443 for Access Control token acquisition)
      *.frontend.clouddatahub.net 443 HTTPS
      *.core.windows.net 443 HTTPS
      login.microsoftonline.com 443 HTTPS
      *.msftncsi.com 443 Used to test internet connectivity if the gateway is unreachable by the Power BI service.
      *.microsoftonline-p.com 443 Used for authentication depending on configuration.

       

      Regards,

      Xiaoxin Sheng