PowerBI PBI On-Premises Gateway Note

From Ittichai Chammavanijakul's Wiki
Jump to: navigation, search
  • GW Config Log

C:\Users\ichamma1\AppData\Local\Microsoft\On-premises data gateway

  • GW Service logs

C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway

MICROSOFT.POWERBI.DATAMOVEMENT.PIPELINE.GATEWAYCORE.DLL.CONFIG

EmitQueryTraces

Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.dll.config

TracingVerbosity

  • Stop/Start gateway service
net stop PBIEgwService 
net start PBIEgwService 
  • Test Connection from Gateway to Power BI Service servers from PowerShell
 
Test-Netconnection -ComputerName www.powerbi.com -Port 80 
Test-Netconnection -ComputerName www.powerbi.com -Port 443 
Test-Netconnection -ComputerName www.analysis.windows.net -Port 443 
Test-Netconnection -ComputerName www.login.windows.net -Port 443 
Test-Netconnection -ComputerName watchdog.servicebus.windows.net -Port 5671 
Test-Netconnection -ComputerName watchdog.servicebus.windows.net -Port 5672 
Test-Netconnection -ComputerName watchdog.servicebus.windows.net -Port 443 
Test-Netconnection -ComputerName watchdog.servicebus.windows.net -Port 9350 
Test-Netconnection -ComputerName watchdog.servicebus.windows.net -Port 9351 
Test-Netconnection -ComputerName watchdog.servicebus.windows.net -Port 9352 
Test-Netconnection -ComputerName watchdog.servicebus.windows.net -Port 9353 
Test-Netconnection -ComputerName watchdog.servicebus.windows.net -Port 9354 
Test-Netconnection -ComputerName www.frontend.clouddatahub.net -Port 443 
Test-Netconnection -ComputerName www.core.windows.net -Port 443 
Test-Netconnection -ComputerName login.microsoftonline.com -Port 443 
Test-Netconnection -ComputerName www.msftncsi.com -Port 443 
Test-Netconnection -ComputerName www.microsoftonline-p.com -Port 443 
telnet watchdog.servicebus.windows.net 9350 
telnet watchdog.servicebus.windows.net 9351 
telnet watchdog.servicebus.windows.net 9352 
telnet watchdog.servicebus.windows.net 9353 
telnet watchdog.servicebus.windows.net 9354 
netsh advfirewall firewall add rule name="Open Port 1521" dir=in action=allow protocol=TCP localport=1521 
netsh advfirewall firewall add rule name=”Open Oracle DB Port 1521″ dir=in action=allow protocol=TCP localport=1521