Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to connect to a SAP BW Query and define parameters. But how?
The April 2017 feature summary for PBI Desktop talks about "enhancements to parameter input experience for SAP HANA & BW". However, theres no live demo in the video and the screenshots are like this one:
When I open my PBI desktop version (april 2017), connect to a BW and select objects similar to the situation in the screenshot above, it looks like this:
How do I switch to the parameter input view?
Hi,
Do you find any solution to this problem? I have the same case with a BEx Query right now.
We tested BW query and cube support again just a week ago and found great improvements. In fact, we decided now to suggest our users to move away from the Excel workaround and try the connector instead. The improvements are:
However, one major requirement can't be met so far:
So no problems on our side any more - to what issue do you refer?
I tell you step by step the detected error.
1) Power BI requests a mandatory parameter for my BEx Query. I expected this.
2) I select two fields of the query to show them in Power BI.
3) I set the mandatory parameter (Seller) and pulse apply.
4) The preview does not filter according to the parameter, it shows all the sellers and that's wrong.
5) However I press to load to detect if there if it filters but neither does it.
Note: I can not attach the images to this platform, it does not recognize the file's path.
Do you know how to solve this error or is it a limitation of Power BI currently?
Best regards.
That corresponds to my earlier finding when the amout of data returned was different from the BW Query output in Excel. That was the reason we recommended to our users to use the intermediate step and loading data from Excel instead...
Quite disturbing if that issue still occurs...
Hi @Sokon,
Firstly, do you connect to SAP BW cube in Power BI Desktop? I would recommend you select dimension and key figures to combine a valid table in Bex Query Designer, then choose the same dimension and key figures in Power BI Desktop navigator.
Secondly, have you defined variables or parameters in your SAP BW model? Once you have created variables or parameters in SAP model as described in the following similar blog, you will be able to get parameter input view in Power BI Desktop.
https://help.sap.com/saphelp_nw70/helpdata/en/ac/789b3c4d4d8d15e10000000a114084/content.htm
Thanks,
Lydia Zhang
Hi @Lydia,
Thanks for your answer! Ok, this is getting confusing. 🙂 This is what I found out together with one of our BW guys:
To avoid getting too much into detail, all I need to know at this point is:
Thanks a lot in advance!
hi,
I know this is an old post but were you able to resolve this?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |