SAP BW connectivity issue

Hi Lydia,

Thanks for your response. I'm using the current version of PowerBI desktop, through Windows 7 - I can enter the server credentials and then all I get when I click ok is a flashing white box in the middle of the screen and the programme freezes.

The trace is giving me the following - any ideas??

DataMashup.Trace Information: 24579 : {"Start":"2016-09-02T13:15:15.1321464Z","Action":"BackgroundThread/RollingTraceWriter/CleanupOldTraces","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":4,"Duration":"00:00:00.0032791"}
DataMashup.Trace Information: 24579 : {"Start":"2016-09-02T13:15:15.1698743Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.2309812"}
DataMashup.Trace Information: 24579 : {"Start":"2016-09-02T13:15:15.4126422Z","Action":"Engine/IO/SAP Business Warehouse/GetProviderFactory","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.0287960"}
DataMashup.Trace Information: 24579 : {"Start":"2016-09-02T13:15:15.4009080Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.0478804"}
DataMashup.Trace Error: 24579 : {"Start":"2016-09-02T13:15:15.5802733Z","Action":"Engine/IO/SAP Business Warehouse/Connection/Open","ConnectionId":"f5a550e8-4ea8-415f-a562-a428ccc7cde1","Exception":"Exception:\r\nExceptionType: Microsoft.Data.SapClient.SapException, Microsoft.Data.SapClient, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1f0823ddf5cc2637\r\nMessage: Connection string is not valid.\r\nStackTrace:\n at Microsoft.Data.SapClient.SapConnectionStringBuilder.ToR3Connection()\r\n at Microsoft.Data.SapClient.SapConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass1.<Trace>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.Trace[T](String method, Func`2 func)\r\n\r\n\r\n","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.0159947"}
DataMashup.Trace Error: 24579 : {"Start":"2016-09-02T13:15:15.5762350Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetryAttempt","Attempt":"0","MaxAttempt":"3","Exception":"Exception:\r\nExceptionType: Microsoft.Data.SapClient.SapException, Microsoft.Data.SapClient, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1f0823ddf5cc2637\r\nMessage: Connection string is not valid.\r\nStackTrace:\n at Microsoft.Data.SapClient.SapConnectionStringBuilder.ToR3Connection()\r\n at Microsoft.Data.SapClient.SapConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass1.<Trace>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.Trace[T](String method, Func`2 func)\r\n at Microsoft.Mashup.Engine1.Library.Common.TracingDbProviderFactoryService.TracingDbConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.SapBusinessWarehouse.SapBwService.<>c__DisplayClass7.<GetDataReader>b__6()\r\n at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n\r\n\r\n","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.0268708"}
DataMashup.Trace Error: 24579 : {"Start":"2016-09-02T13:15:15.5761439Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetry","Exception":"Exception:\r\nExceptionType: Microsoft.Data.SapClient.SapException, Microsoft.Data.SapClient, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1f0823ddf5cc2637\r\nMessage: Connection string is not valid.\r\nStackTrace:\n at Microsoft.Data.SapClient.SapConnectionStringBuilder.ToR3Connection()\r\n at Microsoft.Data.SapClient.SapConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass1.<Trace>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.Trace[T](String method, Func`2 func)\r\n at Microsoft.Mashup.Engine1.Library.Common.TracingDbProviderFactoryService.TracingDbConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.SapBusinessWarehouse.SapBwService.<>c__DisplayClass7.<GetDataReader>b__6()\r\n at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n\r\n\r\n","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.0300544"}
DataMashup.Trace Error: 24579 : {"Start":"2016-09-02T13:15:15.6119640Z","Action":"Engine/IO/SAP Business Warehouse/Connection/Open","ConnectionId":"e994658f-03d6-4e7e-a126-b3fe8f7e66ce","Exception":"Exception:\r\nExceptionType: Microsoft.Data.SapClient.SapException, Microsoft.Data.SapClient, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1f0823ddf5cc2637\r\nMessage: Connection string is not valid.\r\nStackTrace:\n at Microsoft.Data.SapClient.SapConnectionStringBuilder.ToR3Connection()\r\n at Microsoft.Data.SapClient.SapConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass1.<Trace>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.Trace[T](String method, Func`2 func)\r\n\r\n\r\n","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.0001748"}
DataMashup.Trace Error: 24579 : {"Start":"2016-09-02T13:15:15.6118582Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetryAttempt","Attempt":"0","MaxAttempt":"3","Exception":"Exception:\r\nExceptionType: Microsoft.Data.SapClient.SapException, Microsoft.Data.SapClient, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1f0823ddf5cc2637\r\nMessage: Connection string is not valid.\r\nStackTrace:\n at Microsoft.Data.SapClient.SapConnectionStringBuilder.ToR3Connection()\r\n at Microsoft.Data.SapClient.SapConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass1.<Trace>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.Trace[T](String method, Func`2 func)\r\n at Microsoft.Mashup.Engine1.Library.Common.TracingDbProviderFactoryService.TracingDbConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.SapBusinessWarehouse.SapBwService.<>c__DisplayClass7.<GetDataReader>b__6()\r\n at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n\r\n\r\n","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.0004148"}
DataMashup.Trace Error: 24579 : {"Start":"2016-09-02T13:15:15.6118424Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetry","Exception":"Exception:\r\nExceptionType: Microsoft.Data.SapClient.SapException, Microsoft.Data.SapClient, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1f0823ddf5cc2637\r\nMessage: Connection string is not valid.\r\nStackTrace:\n at Microsoft.Data.SapClient.SapConnectionStringBuilder.ToR3Connection()\r\n at Microsoft.Data.SapClient.SapConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass1.<Trace>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.Trace[T](String method, Func`2 func)\r\n at Microsoft.Mashup.Engine1.Library.Common.TracingDbProviderFactoryService.TracingDbConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.SapBusinessWarehouse.SapBwService.<>c__DisplayClass7.<GetDataReader>b__6()\r\n at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n\r\n\r\n","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.0005400"}
DataMashup.Trace Information: 24579 : {"Start":"2016-09-02T13:15:15.1698285Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.4406736"}
DataMashup.Trace Information: 24579 : {"Start":"2016-09-02T13:15:15.1614800Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.2878061"}
DataMashup.Trace Information: 24579 : {"Start":"2016-09-02T13:15:15.4493525Z","Action":"RemotePreviewValueSource/RunStub","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.1634191"}
DataMashup.Trace Information: 24579 : {"Start":"2016-09-02T13:15:15.1454643Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","evaluationID":"1","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.4673341"}
DataMashup.Trace Information: 24579 : {"Start":"2016-09-02T13:15:15.6129121Z","Action":"Engine/IO/SAP Business Warehouse/Connection/Dispose","ConnectionId":"f5a550e8-4ea8-415f-a562-a428ccc7cde1","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.0000340"}
DataMashup.Trace Information: 24579 : {"Start":"2016-09-02T13:15:15.6129642Z","Action":"Engine/IO/SAP Business Warehouse/Connection/Dispose","ConnectionId":"e994658f-03d6-4e7e-a126-b3fe8f7e66ce","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"12c7d27c-cabb-4022-8850-de485df3a18a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":1,"Duration":"00:00:00.0000071"}
DataMashup.Trace Information: 24579 : {"Start":"2016-09-02T13:19:41.2316683Z","Action":"EvaluationHost/TryHandleException","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":3,"Duration":"00:00:00.0105271"}
DataMashup.Trace Error: 24579 : {"Start":"2016-09-02T13:19:41.2469055Z","Action":"EvaluationContainerMain/ExceptionHandler/HandleException","containerID":"1","Exception":"Exception:\r\nExceptionType: System.Threading.AbandonedMutexException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The wait completed due to an abandoned mutex.\r\nStackTrace:\n at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)\r\n at Microsoft.Mashup.Container.EvaluationContainerMain.WaitForParentExitThread(Object state)\r\n at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)\r\n\r\n\r\n","ProductVersion":"2.38.4491.282 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8920,"Tid":3,"Duration":"00:00:00.0001524"}