Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rjm900
Regular Visitor

SAP BW connectivity issue

Hi there,

 

I wonder if anyone can help me. I've been trying to connect PowerBI to SAP BW using the in-built connector, however when I enter the credentials required (server, system number and client ID) and hit enter, all I get is a flashing empty box on screen, and looks like the program goes into an infinate loop which then requires me to CTRL ALT DEL to close PowerBI down.

 

Has anyone else experienced this issue and if so any ideas how to resolve?

 

Many thanks in advance.

 

Richard

3 REPLIES 3
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Hi @rjm900,

Do you use the latest version of Power BI Desktop(2.38.4491.282) to connect to SAP BW? What operating system do you install Desktop on?

In your scenario, please go to File -> Options and settings -> Options -> Diagnostics and click "enable tracing", then connect to SAP DW and check the detailed logs in the traces folder. Also please help to post the detailed logs here.

Besides, please ensure that you install SAP NetWeaver library following the instructions in this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sap-bw-connector/ .


Thanks,

Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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"}

Dear RJM,

 

Request you to follow below steps,

 

  1. Try configuring the Power BI Enterprise Gateway and add data source.
  2. Add data source via Power BI Portal as SAP BIW server.
  3. See , if you are able to authenticate.

OR,

  1. Try installing SAP GUI/Bex on same computer to check if issue is related to authentication or connectivity.

OR,

  1. Please note, at least 8 GB of RAM with more than 4 Core Processor and Windows 8.1 or above OS, is necessary when working with external Databases.
  2. The freezing might be because of OS. So, request you to try the connection through other computer.

OR

  1. Please share the steps by step screenshot, for better understanding.

Also,

  1. Please make sure the SAP NWRFC files used are not corrupted. (you may refer http://community.powerbi.com/t5/Integrations-with-Files-and/SAP-BW-Connector-SAP-NetWeaver-library-S... "

If the issue is still not resolved, please "Send a Frown" or rasie a ticket to Power BI Team.

 

Kindly let me know, if any success or not.

 

Thanks,
Saagar Kinja

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors