Forum Discussion
Power Query connectivity with Bex query
Hi rishirajdeb
Do you mean query parameter in Edit queries?
If so, you could select "manage parameter" to edit the parameter, or select the fields->filter->use the parameter to apply filter.
Please read the documents to use parameters in Power BI successfully.
https://docs.microsoft.com/en-us/power-query/power-query-query-parameters
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Maggie,
Thanks for the reply.
Here we are passing parameters to the source (SAP BW report) system itself, as we want to load only relevant data as per the parameters passed to the BW report.
The parameters are not created in Power BI as we want to pass multiple parameters for some fields, as well as there are parameters which are optional in nature. What we did is we created the parameters on the BEx reports side, and on Power BI edit query, from the applied steps settings ('Added Items' settings) - we are selecting the parameters whatever the BW report is passing. The problem here is that not all the values passed from the BW report are appearing on the selection window (for example - there are 4 periods available while only 2 are getting displayed on the selection screen for users to choose from).
Let me know if you need any further details.
Reagrds