Forum Discussion
Dynamic M Query with REST API
Hi,
I am trying to connect to REST API from POwer BI which is working fine. But is there a way to dynamically pass the parameters values in the API call based on user selection.
For Eg. I have a parameter paramCOUNTRY, which will be exposed to the user as a slicer. Based on user selection from Country slicer, paramCOUNTRY should make dymanic API call and fetch records only relevant to the Country selected by the User.
I understood from my research that, Dynamic M Query works only for Direct query.
Need to understand if it will be supported for REST API as well. any help is appreciated
Regards,
Priyanga
You cannot bind a slicer to a query parameter. If you want a user to be able to select a country like you would with a parameter, you must load all the data pertaining to the country values.
3 Replies
- danextian
Super User
Hi pkn7
M affects the data model but it is not the other way around. What you do in the designer stays in the designer thus a slicer selection cannot be passed back to M. The user will have to change the parameter which will trigger the query to reprocess and reload. If you want to use a slicer then all values of paramCountry from the REST API must be loaded to the model.
