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
I have to conclude that SAP doesn't expose BW to other vendors such as Microsoft, Tableau the same way it does to other SAP applications including SAP BOBJ, since we have no issues doing this basic stuff in SAP Business Objects. I don't want to pull in years of data into Power BI and then let the user slice and dice within this data set. It should rather be dynamically controlled at run time. Thanks for all of the replies!!
You may want to start a new post and see if you can get some better answers. I will agree that no one other than SAP plays nice with SAP. We tried Tableau 5 years ago and that was a disaster and have been using Power BI for about 4 years without any issue. However, we were not a mature company with a lot of BEx reports or BOBJ development. So for us we build as much as we can in our BEx query and then typically just have Power BI pass in the date filters. We also use Power BI to create dashboards (charts/graphs) and not for table based reporting, anything users need in table form or excel still go through BEx Analyzer.
Good luck!