Forum Discussion
SAP BW BEx Dynamic Parameters
Hi Anonymous,
You can follow below blogs to use query parameter in M query.
Power BI Desktop Query Parameters, Part 1
Power BI Desktop Query Parameters, Part2 – Dynamic Data Masking and Query Parameters
Regards,
Yuliana Gu
Not sure how you've set this up but the idea here is that the paramters are dynamic, there is no need to change them. The should populate for you based on the logic that you've written. Look at the last post above your original, you'll see that a paramter was created called TodaysDate and then this value is what gets passed into your M script. Nothing in this post deals with manually changing paramters but rather the paramters are dynimacally/self populated for you.
Now I say this without ever having done a direct connect to SAP BW. So maybe your case is different. That said, could you post your mscirpt or some screenshots of what your tried to achieve so I can have a better idea.
I will admit, I am absolutely new to Power BI. We use SAP Business Objects, Tableau etc., in our environment. All of these reporting, visualization tools allow the user to dynamically interact at report/visualization run-time and change the underlying BW BEx parameters. For example, I as the report author could have created and published company profitability visualization for the 1st Quarter of FY 2020. An end-user would like to refresh this visualization for the 2nd Quarter of FY2020. This is NOT possible in Power BI?