cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kashif
Frequent Visitor

On-premises data gateway (personal mode) Proxy

 

Hi Folks,

 

I have been struggling to get the gateaway running. I found out, it's because of ports are blocked here. So I consulted with the network team and they informed me to used the proxy. I followed the following article, but I coulnd't  find the location and the files mentioned that need modifcation. I have installed "On-Premises Data Gateway (Personal Mode)" version 14.16.6549.2. 

 

https://powerbi.microsoft.com/en-us/guided-learning/powerbi-gateway-proxy/?cdn=disable

 

One thing, in the following guide, I found that there's a windows service which I couldn't find in my server.  

 

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#firewall-or-proxy

 

Appreciate, if anyone can help.

 

Thanks,

Kashif

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: On-premises data gateway (personal mode) Proxy

Hi @kashif,

 

1. You can find the on-premise data gateway (personal mode) configuration file Microsoft.PowerBI.DataMovement.PersonalGateway.exe.config here: C:\Users\<user>\AppData\Local\Microsoft\On-premises data gateway (personal mode). 

 

2. The new personal gateway version named as on-premise data gateway (personal mode) which you run doesn't run as a separate Windows service. After you change settings in configuration file, you need to kill the on-premises data gateway (personal mode) process (Microsoft.PowerBI.DataMovement.PersonalGateway.exe) and relaunch the on-premise data gateway (personal mode). 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kashif
Frequent Visitor

Re: On-premises data gateway (personal mode) Proxy

 

Hi Qiuyun,

 

I'm able to change the proxy now, thank you. 

 

Now, I'm getting the different error, though this is coming whether I use the custom proxy or not. Following text in blue is an excerpt from the main error message, which seems to be the issue.

 

Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.CouldNotUpdateGatewayConfigurationException: Error updating gateway configuration. ----> System.ServiceModel.CommunicationException: The server rejected the upgrade request. 400 This endpoint is only for web-socket requests ----> System.IO.IOException: The server rejected the upgrade request. 400 This endpoint is only for web-socket requests

 

 

Failed to update gateway details. You may need to change the account the gateway runs under.
Error updating gateway configuration.

Server stack trace: 
   at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)
   at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
   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, Int32 maxRetries)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.UpdateGatewayConfiguration(UpdateGatewayConfigurationRequest request, Int32 maxRetries)An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.CouldNotUpdateGatewayConfigurationException: Error updating gateway configuration. ----> System.ServiceModel.CommunicationException: The server rejected the upgrade request. 400 This endpoint is only for web-socket requests ----> System.IO.IOException: The server rejected the upgrade request. 400 This endpoint is only for web-socket requests
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.ServiceBus.Common.AsyncResult.End[TAsyncResult](IAsyncResult result)
   at Microsoft.ServiceBus.ServiceBusClientWebSocket.EndConnect(IAsyncResult result)
   at Microsoft.ServiceBus.Messaging.IteratorAsyncResult`1.StepCallback(IAsyncResult result)
   --- End of inner ExceptionDetail stack trace ---
   at System.Runtime.AsyncResult.End[TAsyncResult](IAsyncResult result)
   at System.ServiceModel.Channels.CommunicationObject.EndOpen(IAsyncResult result)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.ServiceHostController.<ExecuteRunnerIterationAsync>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.ServiceHostController.<StartRunnerAsync>d__14.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.ServiceHostController.StopHandle.<StartRunnerAsync>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.GatewayServiceHost.<UpdateConfigurationImpl>d__24.MoveNext()
   --- End of inner ExceptionDetail stack trace ---
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.GatewayServiceHost.<UpdateConfigurationImpl>d__24.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.PowerBI.DataMovement.Pipeline.Common.TaskUtils.ExtendedWait(Task task, TimeSpan timeout)
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.GatewayServiceHost.UpdateConfiguration(GatewayConfiguration configuration, Int32 maxRetries)
   at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.ExecuteInActivity(PipelineActivityType pipelineActivityType, Action action)
   at SyncInvokeUpdateGatewayConfiguration(Object , Object[] , Object[] )
   at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
   at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
kashif
Frequent Visitor

Re: On-premises data gateway (personal mode) Proxy

Hi Qiuyun,

 

I'm still struggling with Power BI Gateway. I'm getting following error, and don't get any particular one even in Fiddler (see below) the red lines are showing time-out error, not very much helpful. Do I need to ask my network team to whitelist IP? I need to provide the reason for the network team for this. I don't see anything being blocked so far. Am I missing some configuration? or do I need to provide the proxy account, if yes, where to provide that? or is it because we haven't bought the licenses yet? There is so much information on the internet but seems to be outdated.

 

Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.CouldNotUpdateGatewayConfigurationException: Error updating gateway configuration. ----> System.ServiceModel.CommunicationException: The server rejected the upgrade request. 400 This endpoint is only for web-socket requests ----> System.IO.IOException: The server rejected the upgrade request. 400 This endpoint is only for web-socket requests

 

Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.CouldNotUpdateGatewayConfigurationException: Error updating gateway configuration. ----> System.ServiceModel.CommunicationException: The server rejected the upgrade request. 400 This endpoint is only for web-socket requests ----> System.IO.IOException: The server rejected the upgrade request. 400 This endpoint is only for web-socket requests

 

pbig error.png

 

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.