Forum Discussion
[Personal Gateway Upgrade required] The On-premises data gateway (personal mode) is now available
ACTION REQUIRED BY 7/31/2017 to avoid interruption in your Power BI Data refresh of on-premises data
Dimah
Gateway and connectors team
36 Replies
- AnonymousNot applicable
I'm unable to get the new gateway to work.
I uninstalled the old gateway, but am receiving the below error when installing the new. I looked, and the pbiegwservice doesn't exist in my services. So i'm thinking it didn't get created properly? I've tried installing 5 times now, with uninstalling, removing folders, and restarting and still no luck.
Failed to update gateway details. Please try again.
This request operation sent to net.pipe://localhost/powerbi/personalgatewayconfiguration/service did not receive a reply within the configured timeout (00:01:00). The time allotted to this operation may have been a portion of a longer timeout. This may be because the service is still processing the operation or because the service was unable to send a reply message. Please consider increasing the operation timeout (by casting the channel/proxy to IContextChannel and setting the OperationTimeout property) and ensure that the service is able to connect to the client.Server stack trace:
at System.ServiceModel.Dispatcher.DuplexChannelBinder.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.PowerBI.DataMovement.Pipeline.InternalContracts.IGatewayConfigurationService.UpdateGatewayConfiguration(UpdateGatewayConfigurationRequest request)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.UpdateGatewayConfiguration(UpdateGatewayConfigurationRequest request)- IguberkovRegular Visitor
I have exactly the same problem as Anonymous. Got the notification to upgrade, thing didn;t go well. Uninstalled the old personal gateway, tried to install the new one and received the same error. Already tried several installs/uninstalls, restarts. Everything else was working correctly before, so your help on this one would be appreciated.
- dsynan
Advocate III
This worked for me and was provided by the MS support team...
%localappdata%\Microsoft\On-premises data gateway (personal mode)\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config change the value to Https
<setting name="ServiceBusSystemConnectivityModeString" serializeAs="String">
<value>Https</value>
</setting>
Then kill the Microsoft.PowerBI.DataMovement.PersonalGateway.exe process from task manager and restart configuration.
- AnonymousNot applicable
Changing to HTTPS worked, but the refresh now takes considerably longer for my large datasets. This is not a fix, but just a workaround for now.
I had to change to use the non-personal gateway. The personal mode gateway converted all of my connection strings to lowercase for some reason, so it was unable to refresh because of the case not matching drivers on my machine that it was looking for. This is a rediculous issue to have on a production solution....
- AnonymousNot applicableHi Dimazaid,
I'm pro user. I created report one week ago. Yesterday around the same time as now I set up schedule refresh and my all users who are also Pro cannot see my work. They see only message loading data... and almost done... Could you advise how to solve it? I use ODBC data(Service Now connection). Last thing - for me it's working fine. I use old personal gateway and till 6th everything was working fine.- dimazaid
Microsoft Employee
Hi Anonymous,
Which auth type are you using with ODBC? Basic or Windows? Do they see any errors other than the loading data message?
Can you send me the gateway logs so we can take a look?
Thanks!
Dimah- AnonymousNot applicable
It was my mistake. I created dashboard with pinned page and I wanted to create something like menu for reports. I deleted pinned page and left dashboard without it but only text boxes with links to reports. After added again pinned page everything was fine. False alarm :)
One question regarding new on-premises data gateway(personal mode). When I upgrade gateway will I still have an access to my ODBC data? I use Basic authentication.
Thank you.
Regards,
Pawel
- ascendbi
Advocate II
Hi - we installed this update as we have a few data models that use data sources not yet supported by the Data Gateway Enterprise mode.
Unfortunately, we had to uninstall the update as it does not support all the data sources that the existing Personal Gateway supports.
Specifically, we are refreshing Active Directory Data. I recognize (now! :)) that that lack of AD support (along with others) is detailed in the linked documentation under Limitations and considerations, but considering that data refresh via the existing personal gateway will stop working in 7 weeks, I am surprised at the lack of feature parity. I see OLEDB, ODBC, Spark and R being developed, but no AD mention.
dimazaid, while I applaud unifying and simplifying, we are going to have a problem if 2017-07-31 rolls around and On-premises data gateway (personal mode) is not at feature parity for supported connections with the existing Personal Gateway.
- ascendbi
Advocate II
Hi dimazaid,
Any chance we'll get feature parity and have Active Directory support via either Data Gateway? We are very dismayed right now that features that have worked since July 2015 are being removed and breaking all the Intelligence and work we have done. See my related posts about the new 10 GB Uncompressed Data limit imposed on the Data Gateway Refreshes that magically appeared without warning on June 1, 2017.
We have 125 Power BI Pro Licenses. We have now stopped buying them because my confidence has been eroded around what other limitations and restrictions will magically appear. It is clear that we are being funnelled to the Power BI Premium which represents a MASSIVE increase in cost for a company with 230 IT Users. I would feel better about it if I could actually determine if a P1 Node would solve my problem, but there is not test, no trial, no tools to evaluate, etc... Just a web site with a slider and a whitepaper.
Sigh.
- starmoonknight
Helper II
Hi Dimah,
I reinstalled my OS due to a faulty drive thus has directly downloaded the new On-premises data gate way (personal mode). (I used to be a personal gate way user)
After I signed in the gateway, it asked me to update my credentials for datasets the PBI. However, all credentials could be updated but the analysis cube.
I also have some OneDrive files as data sources whose authentication method is also "WindowsWithoutImpersonation" and they worked well.
BTW, I use "my current credential" for the same analysis cube in PBI desktop and it works good. I tried to publish the pbix file again to replace the existing dataset but still got the same error. Not sure what's the issue here. Could that be a local computer configuration issue?
Very much appreciated if you give me sime advise.
Many thanks in advance,
Olivia
- dimazaid
Microsoft Employee
Hi starmoonknight,
Can you check the gateway logs and see what additional info it's providing?
You can find this by going re-opening the gateway from your machine (Start->"On-premises data gateway (personal mode)"), sign in, and click on export logs.
Thanks!
Dimah- starmoonknight
Helper II
Hi dimazaid
Since the log is quite long, I searched for possible key words, and the following is quoted from the log which might be helpful:
......
DM.PersonalGateway Error: 0 : 2017-06-18T23:40:57.3111621Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 435C38AF [DM.Analytics] Performance counters not installed, application performance metrics will not be traced (category = On-premises data gateway)
DM.PersonalGateway Information: 0 : 2017-06-18T23:40:57.6551754Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 CAB8F9C3 [DM.GatewayCore] Attempting to create and start service host for 'Transfer service'
DM.PersonalGateway Information: 0 : 2017-06-18T23:40:57.7706991Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 F3B572FA [DM.GatewayCore] Using configured 'AutoDetect' for ServiceBus ConnectivityMode
DM.PersonalGateway Information: 0 : 2017-06-18T23:40:57.8459589Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 87990171 [DM.GatewayCore] Creating GatewayTransferServiceHost against 'sb://wabi-south-east-asia-relay36.servicebus.windows.net/eedcdc10-bdc2-459d-b8d0-227ce63e01fa/' with following binding configuration: {"ReliableSession":{"Enabled":false,"Ordered":true,"InactivityTimeout":"00:10:00"},"HostNameComparisonMode":0,"ConnectionMode":0,"TransferMode":0,"MaxBufferPoolSize":8500000,"MaxBufferSize":8500000,"MaxConnections":1500,"ListenBacklog":10,"IsDynamic":false,"MaxReceivedMessageSize":8500000,"ReaderQuotas":{"MaxStringContentLength":8192,"MaxArrayLength":16384,"MaxBytesPerRead":4096,"MaxDepth":32,"MaxNameTableCharCount":16384,"ModifiedQuotas":0},"Scheme":"sb","EnvelopeVersion":{"NextDestinationActorValue":"http://www.w3.org/2003/05/soap-envelope/role/next"},"Security":{"Mode":1,"RelayClientAuthenticationType":0,"Transport":{"ProtectionLevel":2},"Message":{"ClientCredentialType":1,"AlgorithmSuite":"Default"}},"CloseTimeout":"00:01:00","Name":"GatewayServiceBusTransferBinding","OpenTimeout":"00:01:00","ReceiveTimeout":"06:00:00","MessageVersion":"Default","SendTimeout":"00:01:00"}
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:00.2643817Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 0756374B [DM.GatewayCore] ServiceEndpoint Connection status: Online, LastError: ''
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:00.2847940Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 500124B1 [DM.GatewayCore] Transfer service started
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:00.2847940Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 0CF4AAA9 [DM.GatewayCore] <ii>sb://wabi-south-east-asia-relay36.servicebus.windows.net/eedcdc10-bdc2-459d-b8d0-227ce63e01fa/</ii>
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:00.3337406Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 0E6D6CC9 [DM.GatewayCore] Successfully created and started service host for 'Transfer service'
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:18.4266036Z DM.PersonalGateway 693b20b4-325a-4007-8963-c65274a87b61 ed2d4621-ebf9-4e4e-b419-3b2ec8bb66d3 MGPP 00000000-0000-0000-0000-000000000000 A08BF3B6 [DM.GatewayCore] Deserialized TestGatewayConnectionRequest, executing
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.2617806Z DM.PersonalGateway 0c832e9b-cc4b-480f-a9da-4b4dcaeca4c8 439b3242-beb8-4d75-9762-e1dca2a08f6b MGPP 88233a60-e569-43d4-a615-62ee291b9a1e E5E3865A [DM.GatewayCore] Deserialized OpenConnectionRequest, executing
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.3137012Z DM.PersonalGateway cbea8389-4947-413f-803b-0b29410b6670 439b3242-beb8-4d75-9762-e1dca2a08f6b MGPP 88233a60-e569-43d4-a615-62ee291b9a1e E5E3865A [DM.GatewayCore] Deserialized OpenConnectionRequest, executing
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.3327019Z DM.PersonalGateway c6ab6a7d-f813-4e5b-a738-931fbd264ab3 439b3242-beb8-4d75-9762-e1dca2a08f6b MGPP 88233a60-e569-43d4-a615-62ee291b9a1e E5E3865A [DM.GatewayCore] Deserialized OpenConnectionRequest, executing
DM.PersonalGateway Warning: 0 : 2017-06-18T23:41:32.5319431Z DM.PersonalGateway 6acb356a-0dde-4241-b3f4-45337aa91553 439b3242-beb8-4d75-9762-e1dca2a08f6b MGGC 88233a60-e569-43d4-a615-62ee291b9a1e 9315B129 [DM.Pipeline.Common] Failed to parse gateway core config file: Object reference not set to an instance of an object.
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.5549177Z DM.PersonalGateway 2b48e621-2c8d-437d-9032-d08ec789a7ec 439b3242-beb8-4d75-9762-e1dca2a08f6b MGCC 88233a60-e569-43d4-a615-62ee291b9a1e 23BF7B0C [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[Basic] Encrypted Credential information omitted</pi>]
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.5549177Z DM.PersonalGateway 8a0b78d0-aed7-4feb-b4e7-28e1d2e66ea2 439b3242-beb8-4d75-9762-e1dca2a08f6b MGCC 88233a60-e569-43d4-a615-62ee291b9a1e 23BF7B0C [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[Basic] Encrypted Credential information omitted</pi>]
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.5629089Z DM.PersonalGateway 8fd162d9-d753-4096-9def-aba9936a0a81 439b3242-beb8-4d75-9762-e1dca2a08f6b MGCC 88233a60-e569-43d4-a615-62ee291b9a1e 1522A50B [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[WindowsWithoutImpersonation] Encrypted Credential information omitted</pi>]
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.6867711Z DM.PersonalGateway 6d304a1a-fb7a-4022-8c68-bad36b698ea5 439b3242-beb8-4d75-9762-e1dca2a08f6b MGCC 88233a60-e569-43d4-a615-62ee291b9a1e 1522A50B [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[WindowsWithoutImpersonation] Encrypted Credential information omitted</pi>]
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.6867711Z DM.PersonalGateway 5f7550f7-5e68-4bf4-bf2e-1aed84444d82 439b3242-beb8-4d75-9762-e1dca2a08f6b MGCC 88233a60-e569-43d4-a615-62ee291b9a1e 1522A50B [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[WindowsWithoutImpersonation] Encrypted Credential information omitted</pi>]
DM.PersonalGateway Information: 0 : 2017-06-18T23:41:32.6867711Z DM.PersonalGateway ed1ec124-0e0d-41c3-b1f3-aa1bcfdec43d 439b3242-beb8-4d75-9762-e1dca2a08f6b MGCC 88233a60-e569-43d4-a615-62ee291b9a1e 1522A50B [DM.GatewayCore] Db pool opening raw database connection to [Microsoft.Mashup.OleDb.1: <pi>Microsoft.Mashup.OleDb.1:TRUNCATED:[WindowsWithoutImpersonation] Encrypted Credential information omitted</pi>]......
Thanks,
Olivia
- pquezadaRegular Visitor
hey hi!
i have the same problem!
i can connect with the SSAS. Power Bi see the cube, but not connet, and show me this error.
¿solution?
and the log gateway:
- klyhneFrequent Visitor
Hi,
I am not able to refresh my data via the Power BI Service. I have no issues refreshing data with Power BI Desktop.
We are using the On-Premises Data Gateway (Personal Mode) in the newest version.
The error I get when trying to refresh is:Last refresh failed: Mon Jul 10 2017 08:15:08 GMT+0200 (Rom, sommertid) We reached the data gateway, but the gateway can't access the on-premises data source. Cluster URI: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net Activity ID: 6fca8717-2ff8-44ad-b392-c0d011051cfe Request ID: e4ab4f72-9440-3d69-c6ae-88aa6f09adf8 Time: 2017-07-10 06:15:08Z
There is no further information about the error.
Any help is very much appreciated.
Regards,
Kristian - klyhneFrequent Visitor
Hi,
We are not able to refresh our dataset via the Power BI Service. We have no issues refreshing in Power BI Desktop.
We are using the On-Premises Data Gateway (Personal mode) in the newest version.
Below is the error information in the Power BI Service:Last refresh failed: Mon Jul 10 2017 08:15:08 GMT+0200 (Rom, sommertid) We reached the data gateway, but the gateway can't access the on-premises data source. Cluster URI: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net Activity ID: 6fca8717-2ff8-44ad-b392-c0d011051cfe Request ID: e4ab4f72-9440-3d69-c6ae-88aa6f09adf8 Time: 2017-07-10 06:15:08Z
Any help is very much appreciated.
Regards,
Kristian - psheridan
Advocate IV
I upgraded to the On-Premises Data Gateway (Personal) now having issues with one of my connections (OLEDB). Tried all authentication options - basic, anonymous and windowswithoutimpersonation...no luck with any of these. Is there a known issue related to OLEDB connections? Please advise what I need to do to get my datasets rescheduled/refreshed.
Thanks
- DavidLFrequent Visitor
Live/Direct Query of OLEDB sources is not supported - could that be the issue?
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-indepth/
- psheridan
Advocate IV
Yes, I think thats the issue (at least w/Personal Mode). I tried installing regular on-prem gateway as well and was able to input datasource information but whenever I clicked "add" nothing happened. Guess now I am stuck manually refreshing and publishing and hopefully a solution for OLEDB is implemented.
- dsynan
Advocate III
dimazaid I have a ticket submitted with the MS support team and they are researching my issue. I cannot get the personal on-prem gateway to install fully and it times out when it's trying to authenticate me as a user. My old Personal Gateway has already been uninstalled. Is there a link or download for the old version that I can use until 7/31? I'm hopeful I will be able to resolve my issue through the MS support team or my own IT helpdesk by then.