Forum Discussion
Parameter as Search option
HI bhanu_gautam, is it really possible?
If we talk about Import storage mode, I expect that PowerQuery is executed when semantic model is refreshing, therefore, any parameter value for API (to be used in PowerQuery) should be provided before semantic model refresh. In such case, when user is interacting with refreshed report (e.g. selecting some value in a slicer visual), it will not affect the refresh, thefore there will be no new API call. Isn't it so?
Maybe it works in a different manner when using DirectQuery, however even in this case, I don't expect that user can change parameter through interaction with a slicer on report canvas.
As of my knowledge, the only way to interact with parameters if not using PowerBI desktop is through "Semantci Models" in PowerBI service:
If you can provide some references where to learn more about your suggestion I'd be very grateful 🙂 Thank you!
Sergii24 , My bad yes you are right it will not work