Forum Discussion
Power BI Analysis Services Connector Issues
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 ...
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
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, executingI 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?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
