Forum Discussion
SAP BW connector parameter input: How?
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:
- Parameter dialog is showing and works as expected
- We couldn't find wrong query results any more
- Faster query results than before
- Support for Windows Authentication
- Support for Additional Member Properties
- Direct Query on BW ist now GA
However, one major requirement can't be met so far:
- Single Sign On for Direct Query still not availlable.
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...
