Forum Discussion
SAP BW connector parameter input: How?
No solution so far, I'm sorry.
I stopped trying to connect directly to BW Queries altogether and import Workbooks instead (the Excel files that contain the results given back by Analyzer) That way works with parameters, is faster, gives back the desired fields and the correct amounts of rows. In my experience, the problems only start when you try to connect to SAP and get worse when you want to use it in production. Additionaly, as you can see, there's not much help to be found on this subject.
Sorry, I do not understand what you meant by SAP workbook - is it the same as BW workbooks?
Sorry i'm not used to SAP teminology - are there other types of workbooks? :-) I mean the excel files that contain the results from the Analyzer query. Does that answer your question?
Okay, got it :) But that means you lose the advantage of having 'live' data since you will have the excel dump taken a while ago, correct?
Yes, that's true. The method requires refreshing the workbook manually or with techniques that are not Power BI. That's a drawback, but provides reliable data quality.