Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Sid07101982
Regular Visitor

Power BI Analysis Services Connector Issues

‎06-08-2016 05:22 PM

Hi Fellows,

 

I am new to this and getting below error when I am trying to add a data source to new Power Bi enterprise gateway. I have checked user has correct permissions and I am using FQDN for server and user. 

 

Can it be realted to ports, do we need to open the ports listed here "https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/#ports"  on server as well or just where enterprise gateway is installed. 

 

Thanks ,

 

Sid

 

Power BI

Unable to connect: We encountered an error while trying to connect to ************** Details: "Unknown error in Enterprise Gateway."Hide details
Activity ID:828bde6c-26e2-451e-a00f-07224472ba17
Request ID:2439f57c-b340-5aa1-3f9c-23c768743077
Cluster URI:https://wabi-australia-southeast-redirect.analysis.windows.net
Status code:400
Error Code:DM_GWPipeline_UnknownError
Time:Thu Jun 09 2016 09:47:12 GMT+1000 (AUS Eastern Standard Time)
Version:13.0.1100.682
Labels:
Message 1 of 6
1,648 Views
0
5 REPLIES 5
dimazaid
Employee
Employee

‎06-09-2016 02:42 PM

hi @Sid07101982,
Is the error showing "******"? or did you add it to hide your server name? If the error is showing this then I think I know what the problem is. If not, what do you see in the Gateway logs? 

C:\Users\PBIEgwService\AppData\Local\Microsoft\Power BI Enterprise Gateway\EnterpriseGateway*.log

 

Message 2 of 6
1,622 Views
0
Sid07101982
Regular Visitor
In response to dimazaid

‎06-09-2016 04:03 PM

Hi @dimazaid,

 

That was to hide the server. Below is the log, not sure what to check in it. I read about UPN yesterday that Power BI connects to SSAS server using  the login name in app.powerbi . Can that be the issue ? 

 

Starting trace on 9/06/2016 12:39:03 AM UTC
Version: 13.0.1500.158


DM.EnterpriseGateway Information: 0 : 2016-06-09T00:39:03.7848764Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	77C42AFE [DM.EnterpriseGateway] Starting Enterprise gateway service
DM.EnterpriseGateway Error: 0 : 2016-06-09T00:39:03.7948764Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	806193F3 [DM.EnterpriseGateway] Error getting or creating Windows event log: The source was not found, but some or all event logs could not be searched.  Inaccessible logs: Security.
DM.EnterpriseGateway Information: 0 : 2016-06-09T00:39:04.0548764Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	D1BCCC47 [DM.GatewayCore] Setting thread pool worker threads = 300, min completion port threads = 300
DM.EnterpriseGateway Information: 0 : 2016-06-09T00:39:04.0548764Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	B1482368 [DM.EnterpriseGateway] Service OnStart
DM.EnterpriseGateway Information: 0 : 2016-06-09T00:39:04.0648764Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	06EC9A10 [DM.GatewayCore] New runner was explicitly started on the 'Configuration service' controller
DM.EnterpriseGateway Information: 0 : 2016-06-09T00:39:04.0648764Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	5FBD3146 [DM.GatewayCore] Attempting to create and start service host for 'Configuration service'
DM.EnterpriseGateway Information: 0 : 2016-06-09T00:39:04.0948764Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	79BDE466 [DM.GatewayCore] Configuration service started
DM.EnterpriseGateway Information: 0 : 2016-06-09T00:39:04.0948764Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	8F619B72 [DM.GatewayCore] Successfully created and started service host for 'Configuration service'
DM.EnterpriseGateway Information: 0 : 2016-06-09T00:39:05.2848764Z DM.EnterpriseGateway	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.EnterpriseGateway Information: 0 : 2016-06-09T00:39:05.3348764Z DM.EnterpriseGateway	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.EnterpriseGateway Information: 0 : 2016-06-09T00:39:05.3948764Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	3F2593B6 [DM.GatewayCore] Creating GatewayTransferServiceHost against 'sb://wabi-australia-southeast-relay32.servicebus.windows.net/ffc079e7-2097-4903-ab30-a6720dfcc877/' 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.EnterpriseGateway Information: 0 : 2016-06-09T00:39:50.7618764Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	500124B1 [DM.GatewayCore] Transfer service started
DM.EnterpriseGateway Information: 0 : 2016-06-09T00:39:50.7618764Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	F6D2DCE0 [DM.GatewayCore]   <ii>sb://wabi-australia-southeast-relay32.servicebus.windows.net/ffc079e7-2097-4903-ab30-a6720dfcc877/</ii>
DM.EnterpriseGateway Information: 0 : 2016-06-09T00:39:50.7818764Z DM.EnterpriseGateway	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.EnterpriseGateway Information: 0 : 2016-06-09T00:43:58.0478764Z DM.EnterpriseGateway	131f2312-e93b-48f3-a9bf-d59e58e47743	eab20954-cdce-0e22-d950-8026099a29e3	MGPP	8d92d16d-2627-03d6-2d9a-d1e02abce5ee	A08BF3B6 [DM.GatewayCore] Deserialized TestGatewayConnectionRequest, executing
 
Message 3 of 6
1,609 Views
0
dimazaid
Employee
Employee
In response to Sid07101982

‎06-09-2016 05:49 PM

I can't see the error in the logs either looking at the timing. 
Can you try adding it again? Is this the only file in the logs' folder? 

Message 4 of 6
1,602 Views
0
Sid07101982
Regular Visitor
In response to dimazaid

‎06-14-2016 04:31 PM

Hi @dimazaid,

 

I tried it again and below is from most updated log file

 

Starting trace on 14/06/2016 11:27:33 PM UTC
Version: 13.0.1500.158


DM.EnterpriseGateway Information: 0 : 2016-06-14T23:27:33.7465865Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	77C42AFE [DM.EnterpriseGateway] Starting Enterprise gateway service
DM.EnterpriseGateway Error: 0 : 2016-06-14T23:27:33.7495865Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	806193F3 [DM.EnterpriseGateway] Error getting or creating Windows event log: The source was not found, but some or all event logs could not be searched.  Inaccessible logs: Security.
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:27:34.0215865Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	D1BCCC47 [DM.GatewayCore] Setting thread pool worker threads = 300, min completion port threads = 300
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:27:34.0245865Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	B1482368 [DM.EnterpriseGateway] Service OnStart
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:27:34.0385865Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	06EC9A10 [DM.GatewayCore] New runner was explicitly started on the 'Configuration service' controller
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:27:34.0405865Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	5FBD3146 [DM.GatewayCore] Attempting to create and start service host for 'Configuration service'
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:27:34.0735865Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	79BDE466 [DM.GatewayCore] Configuration service started
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:27:34.0745865Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	8F619B72 [DM.GatewayCore] Successfully created and started service host for 'Configuration service'
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:27:35.2765865Z DM.EnterpriseGateway	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.EnterpriseGateway Information: 0 : 2016-06-14T23:27:35.3375865Z DM.EnterpriseGateway	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.EnterpriseGateway Information: 0 : 2016-06-14T23:27:35.3945865Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	3F2593B6 [DM.GatewayCore] Creating GatewayTransferServiceHost against 'sb://wabi-australia-southeast-relay32.servicebus.windows.net/ffc079e7-2097-4903-ab30-a6720dfcc877/' 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.EnterpriseGateway Information: 0 : 2016-06-14T23:28:20.4877595Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	500124B1 [DM.GatewayCore] Transfer service started
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:28:20.4887596Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	F6D2DCE0 [DM.GatewayCore]   <ii>sb://wabi-australia-southeast-relay32.servicebus.windows.net/ffc079e7-2097-4903-ab30-a6720dfcc877/</ii>
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:28:20.5107618Z DM.EnterpriseGateway	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'

Before this it asked me to restore my gateway which I did, below is log for it.

 

Starting trace on 14/06/2016 11:20:37 PM UTC
Version: 13.0.1500.158


DM.EnterpriseGateway Information: 0 : 2016-06-14T23:20:37.2618364Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	77C42AFE [DM.EnterpriseGateway] Starting Enterprise gateway service
DM.EnterpriseGateway Error: 0 : 2016-06-14T23:20:37.2668369Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	806193F3 [DM.EnterpriseGateway] Error getting or creating Windows event log: The source was not found, but some or all event logs could not be searched.  Inaccessible logs: Security.
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:20:37.2778380Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	D1BCCC47 [DM.GatewayCore] Setting thread pool worker threads = 300, min completion port threads = 300
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:20:37.2798382Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	B1482368 [DM.EnterpriseGateway] Service OnStart
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:20:37.2938396Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	06EC9A10 [DM.GatewayCore] New runner was explicitly started on the 'Configuration service' controller
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:20:37.2968399Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	5FBD3146 [DM.GatewayCore] Attempting to create and start service host for 'Configuration service'
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:20:37.3348437Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	79BDE466 [DM.GatewayCore] Configuration service started
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:20:37.3348437Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	8F619B72 [DM.GatewayCore] Successfully created and started service host for 'Configuration service'
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:20:37.3448447Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	E7E1BCA0 [DM.GatewayCore] Not starting transfer service because there is no configuration
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:22:26.6387730Z DM.EnterpriseGateway	0018b381-40a9-489c-855f-58ad1d45e680	00000000-0000-0000-0000-000000000000	MFUC	00000000-0000-0000-0000-000000000000	E51AF152 [DM.GatewayCore] Stop runner runner was explicitly invoked on the 'Transfer service' controller
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:22:26.6387730Z DM.EnterpriseGateway	0018b381-40a9-489c-855f-58ad1d45e680	00000000-0000-0000-0000-000000000000	MFUC	00000000-0000-0000-0000-000000000000	1AE00A50 [DM.GatewayCore] Stop for 'Transfer service' did not encounter any startup task
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:22:28.0199111Z DM.EnterpriseGateway	0018b381-40a9-489c-855f-58ad1d45e680	00000000-0000-0000-0000-000000000000	MFUC	00000000-0000-0000-0000-000000000000	44038D21 [DM.GatewayCore] Attempting to start runner for 'Transfer service' from within a stop handle
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:22:28.0199111Z DM.EnterpriseGateway	0018b381-40a9-489c-855f-58ad1d45e680	00000000-0000-0000-0000-000000000000	MFUC	00000000-0000-0000-0000-000000000000	CAB8F9C3 [DM.GatewayCore] Attempting to create and start service host for 'Transfer service'
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:22:28.1279219Z DM.EnterpriseGateway	0018b381-40a9-489c-855f-58ad1d45e680	00000000-0000-0000-0000-000000000000	MFUC	00000000-0000-0000-0000-000000000000	F3B572FA [DM.GatewayCore] Using configured 'AutoDetect' for ServiceBus ConnectivityMode
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:22:28.2149306Z DM.EnterpriseGateway	0018b381-40a9-489c-855f-58ad1d45e680	00000000-0000-0000-0000-000000000000	MFUC	00000000-0000-0000-0000-000000000000	3F2593B6 [DM.GatewayCore] Creating GatewayTransferServiceHost against 'sb://wabi-australia-southeast-relay32.servicebus.windows.net/ffc079e7-2097-4903-ab30-a6720dfcc877/' 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.EnterpriseGateway Information: 0 : 2016-06-14T23:23:13.7034790Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	500124B1 [DM.GatewayCore] Transfer service started
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:23:13.7034790Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	F6D2DCE0 [DM.GatewayCore]   <ii>sb://wabi-australia-southeast-relay32.servicebus.windows.net/ffc079e7-2097-4903-ab30-a6720dfcc877/</ii>
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:23:13.7264813Z DM.EnterpriseGateway	0018b381-40a9-489c-855f-58ad1d45e680	00000000-0000-0000-0000-000000000000	MFUC	00000000-0000-0000-0000-000000000000	0E6D6CC9 [DM.GatewayCore] Successfully created and started service host for 'Transfer service'
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:23:14.9756062Z DM.EnterpriseGateway	a5871c39-6073-4f9c-8d69-608eb1219e16	0d018e7a-c7fa-465a-a018-a9f47bfda034	MGPP	00000000-0000-0000-0000-000000000000	A08BF3B6 [DM.GatewayCore] Deserialized TestGatewayConnectionRequest, executing
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:23:28.6029688Z DM.EnterpriseGateway	aa6cc4b2-3e73-494d-897e-9b7e763c3763	5e0b87cd-470c-9800-7b41-908c7bd64d80	MGPP	c1aa6dc7-6a4f-4096-a75f-cb7e39e0acd5	A08BF3B6 [DM.GatewayCore] Deserialized TestGatewayConnectionRequest, executing
DM.EnterpriseGateway Information: 0 : 2016-06-14T23:27:30.6845865Z DM.EnterpriseGateway	85da3db6-470f-45cb-b5f2-9faf87a0b1da	ee29e10b-1cc7-af2a-0e71-adf31782beb6	MGPP	c1aa6dc7-6a4f-4096-a75f-cb7e39e0acd5	7683252B [DM.GatewayCore] Deserialized EncryptCredentialsWithTestConnectionRequest, executing
Message 5 of 6
1,580 Views
0
Sid07101982
Regular Visitor
In response to Sid07101982

‎06-15-2016 06:24 PM

Dear @dimazaid,

 

I was able to resolve error realated to "not able to write to eventlog" by giving NT SERVICE\PBIEgwservice admin rights. Below is the log from latest attempt. This does not show any error but I am still getting error while adding analysis service data source.  Can this be realted to permission? The user I am trying to connect with has Server Adminstrator role granted to it at SSAS Instance.

 

 

Starting trace on 16/06/2016 1:10:49 AM UTC
Version: 13.0.1500.158


DM.EnterpriseGateway Information: 0 : 2016-06-16T01:10:49.5396714Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	77C42AFE [DM.EnterpriseGateway] Starting Enterprise gateway service
DM.EnterpriseGateway Information: 0 : 2016-06-16T01:10:49.8697044Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	D1BCCC47 [DM.GatewayCore] Setting thread pool worker threads = 300, min completion port threads = 300
DM.EnterpriseGateway Information: 0 : 2016-06-16T01:10:49.8717046Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	B1482368 [DM.EnterpriseGateway] Service OnStart
DM.EnterpriseGateway Information: 0 : 2016-06-16T01:10:49.8847059Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	06EC9A10 [DM.GatewayCore] New runner was explicitly started on the 'Configuration service' controller
DM.EnterpriseGateway Information: 0 : 2016-06-16T01:10:49.8867061Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	5FBD3146 [DM.GatewayCore] Attempting to create and start service host for 'Configuration service'
DM.EnterpriseGateway Information: 0 : 2016-06-16T01:10:49.9187093Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	79BDE466 [DM.GatewayCore] Configuration service started
DM.EnterpriseGateway Information: 0 : 2016-06-16T01:10:49.9187093Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	8F619B72 [DM.GatewayCore] Successfully created and started service host for 'Configuration service'
DM.EnterpriseGateway Information: 0 : 2016-06-16T01:10:49.9477122Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	59C11ABB [DM.EnterpriseGateway] Started the 'Power BI Enterprise Gateway Service' service.
DM.EnterpriseGateway Information: 0 : 2016-06-16T01:10:51.2078382Z DM.EnterpriseGateway	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.EnterpriseGateway Information: 0 : 2016-06-16T01:10:51.2648439Z DM.EnterpriseGateway	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.EnterpriseGateway Information: 0 : 2016-06-16T01:10:51.3218496Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	3F2593B6 [DM.GatewayCore] Creating GatewayTransferServiceHost against 'sb://wabi-australia-southeast-relay32.servicebus.windows.net/ffc079e7-2097-4903-ab30-a6720dfcc877/' 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.EnterpriseGateway Information: 0 : 2016-06-16T01:11:36.7183888Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	500124B1 [DM.GatewayCore] Transfer service started
DM.EnterpriseGateway Information: 0 : 2016-06-16T01:11:36.7183888Z DM.EnterpriseGateway	00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000	0000	00000000-0000-0000-0000-000000000000	F6D2DCE0 [DM.GatewayCore]   <ii>sb://wabi-australia-southeast-relay32.servicebus.windows.net/ffc079e7-2097-4903-ab30-a6720dfcc877/</ii>
DM.EnterpriseGateway Information: 0 : 2016-06-16T01:11:36.7413911Z DM.EnterpriseGateway	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'
Message 6 of 6
1,567 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All