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
Maybe I am missing something here. The issue still persists. I have a test Power BI analytic that "direct queries" SAP BW. It works fine in Power BI desktop client and I can change BEx query parameters within the Power BI desktop environment. However, the moment I publish it, I no longer can see the BEx query parameters in order to change the parameter values at runtime. Am I missing something here?
Thanks
Jagannathan Santhanam
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?
I've never taken the approach that your going after, we typically just load 1-2 years worth of data into Power BI and provide report filters to allow the user to filter by year, qtr, month, etc. In fact all of our power bi reports are exactly like this and we've had no performance issues or issues with report growing consuming to much storage space. That said, I believe there is a way to create paramters that allow you to adjust those at run time and then refresh the data based on those. You probalby want to look at the 'Manage Paramters' on the Home tab in power query. I believe that you can create paramters that you can wire up into your query and they allow you to change those at run time. You'll most likely not find any examples of this based on SAP but you should find some examples utilizing SQL Server.
Try this link:
https://channel9.msdn.com/Blogs/MVP-Azure/Pass-parameter-to-SQL-Queries-statement-using-Power-BI