Business IntelligenceOffice 365SQLHow to Create Troubleshoot and Resolve PowerBI Gateway Issues June 21, 20168443 views0Share By IG ShareTable of ContentsNote: If you buy something from our links, we might earn a commission. See our disclosure statement. How to Create Troubleshoot and Resolve PowerBI Gateway IssuesInstallation best practices for Power BI GatewayHow to do a clean install of Power BI GatewayHow to Troubleshoot Datasource IssuesHow to Create Troubleshoot and Resolve PowerBI Gateway IssuesThe Power BI gateway is a Windows based application which allows you to connect to your on-premises data-source. Typically, you would need to install the application on an always-on server machine in the same network where your data-sources reside which you would need to connect. Power BI has become popular in the BI world and a lot of users use the gateway app. During the process of using the gateways, Users have faced issues either installing or trying to connect to a data-source. In this post, I am going to talk about how to create troubleshoot and resolve PowerBI gateway issues.Installation best practices for Power BI GatewayDo not install the Power BI Gateway (Enterprise or Personal) on a domain controller.The Windows user account should have the “Logon as a Service” permission. Ensure your Group Policy allows this.If the “Operation is timed out” ensure you have enough system resources to install the gateway.Do-not try to install more than one gateways on the same physical or virtual machine. Side-by-Side installation of Data Management Gateway or SSAS-Connector is not supported. You need to un-install all gateways prior to the new gateway installation.Ensure network connectivity or proxy settings before installation the Power BI gateway.Ensure you are installing the latest version of Power BI gateway.Enterprise gateway does-not support “imported data“. If you have imported data into a file or excel, try using the personal gateway.Always Use Event Logs>Applications and Services Logs>Power BI Enterprise Gateway Service for debugging.How to do a clean install of Power BI GatewaySometimes, the older version of the gateway might preserve the configuration files which needs to be removed. Here are the simple steps to remove them:Step 1: Go-to command prompt and issue the following command:net stop PBIEgwServiceStep 2: Uninstall the Enterprise or Personal gateway from “Programs and Features”Step 3: Delete the installation directory folderc:Program FilesPower BI Enterprise Gatewayc:Program FilesPower BI Personal GatewayHow to Troubleshoot Datasource IssuesEnsure that the Data-source that you are trying to connect is supported.Ensure that the authentication type for the data-source is valid.Verify the Database name and the credentials are valid.If none of the above mentioned steps work, validate connectivity to the data-source from the Server/Virtual Machine which is hosting the gateway.The Data-source and the underlying data-set needs to match. Try using the Source IP address instead of using the host-name to troubleshoot.Ensure the “EffectiveUserName” is valid and have full permissions to the data-source.Check if Firewall or Proxy Settings are ValidRun the following Power-Shell script:Test-NetConnection -ComputerName powerbicomp.servicebus.windows.net -Port 9350Result should be true, else check the connection settings.ComputerName : powerbicomp.servicebus.windows.net RemoteAddress : 70.37.104.321 RemotePort : 5672 InterfaceAlias : vEthernet (Broadcom NetXtreme Gigabit Ethernet - Virtual Switch) SourceAddress : 10.120.60.108 PingSucceeded : False PingReplyDetails (RTT) : 0 ms TcpTestSucceeded : TrueVisit the Official Site for More resources:Troubleshooting Power BI Gateway – PersonalData refresh in Power BITroubleshooting the Power BI Gateway – Enterprise Affiliate Disclosure: Faceofit.com is a participant in the Amazon Services LLC Associates Program. As an Amazon Associate we earn from qualifying purchases. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0
Office 365How to Fix Deleted Reoccurring Meeting Recreating Itself on Outlook 2016 By IGOctober 14, 2017
Office 365Fix Problems with Microsoft Word Not Opening or Responding in Windows By IGDecember 12, 2016
Business IntelligenceDownload Full and Complete List of Power BI Service & Desktop SamplesPower BI is a cloud-based data visualization tool from Microsoft. Power BI is arguably the ...
Tech PostsSQL Server Master Data Services Performance Tuning GuidelinesSQL Server Master Data Services Performance Tuning Guidelines Master Data Services is a MDM (Master ...
Business IntelligenceWhat are Data analysis expressions DAX with ExamplesWhat are Data analysis expressions DAX with Examples DAX is an expression language from Microsoft ...
Business IntelligenceData Analytics in Excel 2016Data Analytics in Excel 2016 Note: If you buy something from our links, we might ...