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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MatheusLPS
Helper I
Helper I

SAP BW Connector do not work with June update

I was happy with May update.

 

Just updated now and BW connector do not work.

 

Windows x64

SAP GUI 7.4

Power BI x64.

 

I downlaod from SAP the x64 libs and put all together on system32 like I did last month. Not working,

 

Trace:

 

Feedback Type:
Frown (Error)

Timestamp:
2017-06-14T17:24:34.3815297Z

Local Time:
2017-06-14T14:24:34.3815297-03:00

Product Version:
2.47.4766.542 (PBIDesktop) (x64)

Release:
June, 2017

IE Version:
11.0.9600.18665

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 pt-BR)

CLR Version:
4.6.1 or later [Release Number = 394271]

Workbook Package Info:
1* - pt-BR, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Peak Working Set:
403 MB

Private Memory:
342 MB

Peak Virtual Memory:
3.72 GB

Error Message:
Error during extraction -> RfcInvoke failed(RFC_ABAP_EXCEPTION): NOT_AUTHORIZED

Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Error during extraction -> RfcInvoke failed(RFC_ABAP_EXCEPTION): NOT_AUTHORIZED ---> Microsoft.Data.SapClient.Extractors.XtractException: Error during extraction -> RfcInvoke failed(RFC_ABAP_EXCEPTION): NOT_AUTHORIZED ---> Microsoft.Data.SapClient.Extractors.XtractException: Error during extraction -> RfcInvoke failed(RFC_ABAP_EXCEPTION): NOT_AUTHORIZED ---> Microsoft.Data.SapClient.ABAPProgramException: RfcInvoke failed(RFC_ABAP_EXCEPTION): NOT_AUTHORIZED
   at Microsoft.Data.SapClient.Base.NW.NwApi.CallFunction(IntPtr client, IntPtr function)
   at Microsoft.Data.SapClient.Base.NW.NwClientFunction.CallApi()
   at Microsoft.Data.SapClient.Base.NW.NwClientFunction.Execute(String tid)
   at Microsoft.Data.SapClient.Base.RFCFunction.ExecuteImplementation(String tid)
   at Microsoft.Data.SapClient.Base.RFCFunction.Execute()
   at Microsoft.Data.SapClient.Base.Utils.ReadTable.ExecuteRFC_READ_TABLE(RFCFunction& f)
   at Microsoft.Data.SapClient.Base.Utils.ReadTable.Run()
   at Microsoft.Data.SapClient.Extractors.TableExtractor.DoClassicExtraction()
   --- End of inner exception stack trace ---
   at Microsoft.Data.SapClient.BufferedResultExtractor.GetPackage(Boolean startIfNotRunning)
   at Microsoft.Data.SapClient.SelectTableCommand.GetNextExecutionResult(ExecutionContext context)
   at Microsoft.Data.SapClient.SapDataReader.<Read>b__52_0()
   at Microsoft.Data.SapClient.SapDataReader.Execute[T](String callerMethodName, Boolean checkResultDescription, Boolean checkResult, Boolean checkRow, Func`1 executeFunc)
   at Microsoft.Data.SapClient.SapDataReader.Execute[T](String callerMethodName, Boolean checkResultDescription, Boolean checkResult, Func`1 executeFunc)
   at Microsoft.Data.SapClient.SapDataReader.Read()
   at Microsoft.Mashup.Engine1.Library.Common.DbData.CachingDbDataReader.<>c__DisplayClass5.<WrappedRead>b__4()
   at Microsoft.Mashup.Engine1.Library.SapBusinessWarehouse.SapBwService.HandleExceptions(Action action)
   at Microsoft.Mashup.Engine1.Library.Common.DbData.CachingDbDataReader.WrappedRead()
   at Microsoft.Mashup.Engine1.Library.Common.DbData.CachingDbDataReader.Read()
   at Microsoft.Mashup.Engine1.Library.SapBusinessWarehouse.SapBwVariablesCollection.RetrieveAdditionalMetadata(Dictionary`2 variables, Dictionary`2 uniqueIdentifiers)
   at Microsoft.Mashup.Engine1.Library.SapBusinessWarehouse.SapBwVariablesCollection.EnsureInitialized()
   at Microsoft.Mashup.Engine1.Library.SapBusinessWarehouse.SapBwVariablesCollection.GetEnumerator()
   at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
   at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
   at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
   at Microsoft.Mashup.Engine1.Library.SapBusinessWarehouse.SapBwCubeContextProvider.SapBwCubeContext.GetParameters(CubeValue cube)
   at Microsoft.Mashup.Engine1.Library.Cube.CubeContextCubeValue.EnsureParametersProvided()
   at Microsoft.Mashup.Engine1.Library.Cube.CubeContextCubeValue.GetEnumerator()
   at Microsoft.Mashup.Engine1.Runtime.TableValue.Microsoft.Mashup.Engine.Interface.ITableValue.GetEnumerator()
   at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
   at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
   at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass5.<RunStub>b__3()
   at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
   --- End of inner exception stack trace ---
   at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass7.<TryReportException>b__6()
   at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
   at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
   at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)
   at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass1e`1.<OnBeginGetResult>b__1b()
   at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
   at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
   at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
   at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
   at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
   at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)
   at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
   at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
   --- End of inner exception stack trace ---
   at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
   at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
   at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
   at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

Invocation Stack Trace:
   at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
   at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
   at Microsoft.Mashup.Client.ClientShared.Ux.HtmlForm.<>c__DisplayClass6.<OnAjaxException>b__5()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Delegate.DynamicInvokeImpl(Object[] args)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
   at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
   at Microsoft.Mashup.Client.ClientShared.Ux.FloatingDialog.NavigatorFloatingDialog.ShowEditLoad(IWin32Window owner, WindowsHost windowsHost, Query query, ITelemetryService telemetryService)
   at Microsoft.Mashup.Client.ClientShared.DataImporter.ShowNavigatorOnSourceQuery(Query query, IEnumerable`1& importedQueries)
   at Microsoft.Mashup.Client.ClientShared.DataImporter.ImportNavigationSource(Query query)
   at Microsoft.Mashup.Client.ClientShared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)
   at Microsoft.Mashup.Client.ClientShared.DataImporter.<>c__DisplayClass1b.<OnQuerySettingsResolved>b__18()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Delegate.DynamicInvokeImpl(Object[] args)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
   at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
   at Microsoft.PowerBI.Client.Program.<>c__DisplayClassd.<Main>b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)


User ID:
b566a285-3015-451a-81d4-4c96b6dd7837

Session ID:
2298f8ff-5c88-40ed-b9b3-d5b82a3b0587

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\lopes25\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot255955981.zip

Performance Trace Logs:
C:\Users\lopes25\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_Snowflake
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_allowBiDiCrossFilterInDirectQuery
PBI_pivotTableVisualEnabled
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_PbiServiceLiveConnect
PBI_daxTemplatesEnabled
PBI_relativeDateSlicer
CustomConnectors

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

shared #"NavigatorBase_1f0e56ad-31dd-4602-aa2d-c13df37c7706" = let
    Source = SapBusinessWarehouse.Cubes("ggaap014.gerdau.net", "33", "360", [ScaleMeasures=false])
in
    Source;
15 REPLIES 15
jjgb
Employee
Employee

One workaround (until a new Power BI release with a fix is available) is to ask the SAP BW admin to give the SAP BW user access to these tables:

RSZGLOBV and RSDCHABAS when the query/cube has variables

RSTHIERNODE and RSHIEDIR when the query/cube has hierarchy node variables

jjgb
Employee
Employee

One workaround (until a new Power BI release with a fix is available) is to ask the SAP BW admin to give the SAP BW user access to these tables:

RSZGLOBV and RSDCHABAS when the query/cube has variables

RSTHIERNODE and RSHIEDIR when the query/cube has hierarchy node variables 

 

 

saguado
Frequent Visitor

Hi,

 

Same for me here. I was able until yesterday to refresh my reports but today after upgrading PBI to june version, refresh fails with the message: rfc_abap_exception: NOT_autorized

I am having the same issue. rfc_abap_exception: NOT_autorized.

 

It happens when the SAP table is designed to ask for parameters.

 

The regular SAP tables are working good.

Same here for me, it's not working anymore since June update 😞

I downgraded to May update and worked again for me. So, waiting for July update with issue solved.

Hello. I just tried July update and the problem is still not corrected. 😞

Anonymous
Not applicable

@GregoryDF@saguado@Mgfjd123@MatheusLPS

 

I m not from SAP background and do not understand the need for this parameter [ScaleMeasures=false] when connecting to Bex query as in

 

 

let
    Source = SapBusinessWarehouse.Cubes(<server ip>, <system number>, <port number>, [ScaleMeasures=false]),

Try removing it and see if scheduling works. It seemed to work for me.

I removed ScaleMeasures=false and I am able to schedule refresh as well. I am not sure what ScaleMeasures does ?

Anonymous
Not applicable

Yes even I noticed this thing. Quite strange, isn't it?

😞 It's still not working on my side.

In fact, it was working fine before the july update of the gateway and only PBI desktop was unable to update my SAP BW data.

 

About that, I checked with the SAP team here and it's caused by lack of authorizations on some tables. Below is the list Microsoft gave me:

RSTHIERNODE: only used when there are hierarchy node variables
• RSZGLOBV: only used when there are characteristic or hierarchy node variables
• RSDCHABAS: only used when there are characteristic or hierarchy node variables, and only if RSZGLOBV had values
• RSHIEDIR: only used when there are hierarchy node variables that point to external hierarchies (very unlikely)

 

SAP security team is currently upgrading my security rights so it's not yet solved for me, but at least one of the admin tried to access the same tables as me with the July update of PBI Desktop and he was able to do it properly.

 

Hope it helps 🙂

Hello. Just an update to say that the problem is now solved for us, with the proposed solution (adding authorizations from BW security to the 4 tables to our roles).

 

Now it's working fine either in Desktop or Service.

 

And also, we had the problem with digits not loading properly, it can be set up in SAP Logon with transaction SU3 under number formating.

 

🙂 Now the last thing is that's it's very slow, but at least it's working 🙂

Anonymous
Not applicable

Hello,

 

We are struggling with the same thing but granting authorisation to those 4 tables does not seem to help 😞 Is there anything additional which was done to handle it?

Not that I'm aware of.

They granted us security on those tables and obviously the ones we're supposed to get data from, but aside from that, nothing specific.

 

Have you verified that except from Power BI, you're able to get the data you want from other tools like Webi?

Anonymous
Not applicable

I disconnected and tried again and it works! Thank you so much for the solution, it is a big help indeed 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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