PowerBI PBI On-Premises Gateway Note

From Ittichai Chammavanijakul's Wiki
Revision as of 18:03, 8 September 2018 by Ittichai (talk | contribs) (Created page with "*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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to 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
Retrieved from "https://ittichaicham.com/wiki/index.php?title=PowerBI_PBI_On-Premises_Gateway_Note&oldid=1213"