Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all.
I'm trying to install the Power BI Data Gateway on a computer which happens to be running Windows Server Standard 2007 but without any success. I have installed the personal version on my laptop but need a "always on" computer for the dashboards and reports to work.
However, when installing it, it keeps failing with the error of:
MSI (s) (6C:FC) [12:12:59:250]: Created Custom Action Server with PID 4956 (0x135C). MSI (s) (6C:E4) [12:12:59:374]: Running as a service.
MSI (s) (6C:E4) [12:12:59:374]: Hello, I'm your 32bit Elevated custom action server.
MSI (s) (6C:68) [12:13:00:500]: Executing op: ActionStart(Name=InstallServices,Description=Installing new services,Template=Service: [2])
MSI (s) (6C:68) [12:13:00:515]: Executing op: ProgressTotal(Total=1,Type=1,ByteEquivalent=1300000)
MSI (s) (6C:68) [12:13:00:515]: Executing op: ServiceInstall(Name=PBIEgwService,DisplayName=On-premises data gateway service,ImagePath="C:\Program Files\On-premises data gateway\Microsoft.PowerBI.EnterpriseGateway.exe",ServiceType=16,StartType=2,ErrorControl=32769,,,,StartName=NT SERVICE\PBIEgwService,Password=**********,Description=The on-premises data gateway service)
MSI (s) (6C:68) [12:13:01:843]: Product: EgwComponents -- Error 1923. Service 'On-premises data gateway service' (PBIEgwService) could not be installed. Verify that you have sufficient privileges to install system services. Error 1923. Service 'On-premises data gateway service' (PBIEgwService) could not be installed. Verify that you have sufficient privileges to install system services.
MSI (s) (6C:68) [12:13:01:843]: User policy value 'DisableRollback' is 0
MSI (s) (6C:68) [12:13:01:843]: Machine policy value 'DisableRollback' is 0 Action ended 12:13:01: InstallFinalize. Return value 3.
So if I understand the message correctly, it is telling me that it cannot a service could not be installed due to insufficient privileges on the computer, however, my user is within the administrators group.
Having read several fixes for this problem on here, none work in my particular instance. I cannot alter anything within the local policies, user rights assignments and then log on as a service since everything ia greyed out with the text underneath complaining the service not being compatiable with Windows 2000 service pack 1 and it update to something much later!
Any help would be gratefully received. Thanks
Solved! Go to Solution.
@jigr69,
Firstly, according to the above error message, you are installing on-premises gateway but not on-premises gateway(personal mode). As per this article, on-premises gateway can only be installed on 64-bit version of Windows 7/Windows Server 2008 R2(or later), please ensure that your server meets this requirement.
Secondly, when installing the on-premises gateway, please ensure that you right-click the setup package and select “Run as administrator” to start the installation. Also turn off any antivirus software in case that it blocks the installation of Power BI gateway.
Regards,
Lydia
i m facing the same problem plzz someone help me
Hi all - I'm a new user of Power BI Pro (prior experience with Cognos) and am simply trying to get a new dashboard available. Installed the Personal Data Gateway on my Windows 10 Pro, 64-bit VM which is where Power BI Desktop is installed. After creating and publishing a dashboard to the service using Excel data tables as my source, I've had to go into Power BI Settings Data Sets and select the Personal Gateway and Apply that change. But then it tells me with a popup that something went wrong (see below).
When trying to reinstall the Personal Gateway, it tells me that it's installed.
Any help is greatly appreciated.
Thanks!
David
Something went wrong
Failed to use the selected gateway. Please make sure the gateway is up and running and try again.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 1825ca75-5e1c-4710-97b6-a9bf4ef2980f
Request ID: edf6e846-5a00-1605-82ac-87a783bd864e
Correlation ID: 06d6244c-0546-63d8-4b5f-c1bd191d6a30
Status code: 400
Time: Sat Jun 06 2020 00:30:30 GMT-0400 (Eastern Daylight Time)
Service version: 13.0.13456.212
Client version: 2005.4.01272-train
Cluster URI: https://wabi-us-central-a-primary-redirect.analysis.windows.net/
I have the same error when installing the gateway on Windows Server 2008 R2. I already install Framework 4.6:
MSI (s) (28:68) [11:39:56:561]: Created Custom Action Server with PID 7744 (0x1E40).
MSI (s) (28:18) [11:39:56:623]: Running as a service.
MSI (s) (28:18) [11:39:56:623]: Hello, I'm your 32bit Elevated custom action server.
MSI (s) (28:58) [11:39:56:717]: Executing op: ActionStart(Name=InstallServices,Description=Installing new services,Template=Service: [2])
MSI (s) (28:58) [11:39:56:717]: Executing op: ProgressTotal(Total=1,Type=1,ByteEquivalent=1300000)
MSI (s) (28:58) [11:39:56:717]: Executing op: ServiceInstall(Name=PBIEgwService,DisplayName=On-premises data gateway service,ImagePath="C:\Program Files\On-premises data gateway\Microsoft.PowerBI.EnterpriseGateway.exe",ServiceType=16,StartType=2,ErrorControl=32769,,,,StartName=NT SERVICE\PBIEgwService,Password=**********,Description=The on-premises data gateway service)
MSI (s) (28:58) [11:39:57:138]: Product: GatewayComponents -- Error 1923. Service 'On-premises data gateway service' (PBIEgwService) could not be installed. Verify that you have sufficient privileges to install system services.
Error 1923. Service 'On-premises data gateway service' (PBIEgwService) could not be installed. Verify that you have sufficient privileges to install system services.
MSI (s) (28:58) [11:39:57:138]: User policy value 'DisableRollback' is 0
MSI (s) (28:58) [11:39:57:138]: Machine policy value 'DisableRollback' is 0
Action ended 11:39:57: InstallFinalize. Return value 3.
MSI (s) (28:58) [11:39:57:153]: Executing op: Header(Signature=1397708873,Version=405,Timestamp=1332436214,LangId=1033,Platform=589824,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
I am having a similar Problem installing the Gateway on My server. The server is windows server 2012 R2, 64 bit, 8 core, 12 GB RAM, and have .NET 4.5.
I run the installer as administrator, and it almost immediately crashes. This is what the error output shows.
Problem signature:
Problem Event Name: CLR20r3
Problem Signature 01: PowerBIGatewayInstaller.exe
Problem Signature 02: 14.16.6464.1
Problem Signature 03: 59c0a4e1
Problem Signature 04: PowerBIGatewayInstaller
Problem Signature 05: 14.16.6464.1
Problem Signature 06: 59c0a4e1
Problem Signature 07: 3c
Problem Signature 08: 1d
Problem Signature 09: System.Windows.Markup.XamlParse
OS Version: 6.3.9600.2.0.0.272.7
Locale ID: 1033
Additional Information 1: 9b1d
Additional Information 2: 9b1d8426cbdd84936a2a7b3936a24820
Additional Information 3: 884f
Additional Information 4: 884fd40582a0bf4f8ef4e1b1e50bce6f
Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid=280262
If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt
Hi,
I also have this issue of the "PowerBIGatewayInstaller Stopped Working" immediatly when starting the program.
- tried run as admin
- tried on multiple servers, meeting the requirements ( win2012R2 , .net , ....)
- I am local admin on all the servers
- disabled the local antivrus ( symantec endpoint)
Error detailed info ...
Problem signature:
Problem Event Name: CLR20r3
Problem Signature 01: PowerBIGatewayInstaller.exe
Problem Signature 02: 14.16.6584.1
Problem Signature 03: 5a5eae17
Problem Signature 04: PowerBIGatewayInstaller
Problem Signature 05: 14.16.6584.1
Problem Signature 06: 5a5eae17
Problem Signature 07: 3c
Problem Signature 08: 1d
Problem Signature 09: System.Windows.Markup.XamlParse
OS Version: 6.3.9600.2.0.0.272.7
Locale ID: 2057
Additional Information 1: 150b
Additional Information 2: 150b7dcd149277ac313df1f28802824e
Additional Information 3: 19cd
Additional Information 4: 19cde1d11521975f5c38056385345d2a
Issue solved after installing the .NET 4.6
After much frustration and having previously had no problems when installing on-prem gateways.... Installing .NET 4.6 worked for me too.
@jigr69,
Firstly, according to the above error message, you are installing on-premises gateway but not on-premises gateway(personal mode). As per this article, on-premises gateway can only be installed on 64-bit version of Windows 7/Windows Server 2008 R2(or later), please ensure that your server meets this requirement.
Secondly, when installing the on-premises gateway, please ensure that you right-click the setup package and select “Run as administrator” to start the installation. Also turn off any antivirus software in case that it blocks the installation of Power BI gateway.
Regards,
Lydia
I think the issue is down to this:
Personal gateway fails to install as a service even though you are a local administrator for the computer - Installation can fail if the user is in the computer’s local Administrator group, but group policy does not allow that username to log on as a service. At the moment, ensure the group policy allows a user to log on as a service. We’re working on a fix for this issue.
I wonder when Microsoft are going to fix this?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |