Dynamic M Query with REST API

[pkn7]

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

[danextian]

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.

[pkn7]

Hi @danextian ,

Is there a way to bind the slicer to paramCOUNTRY?

Regards,

Priyanga

[danextian · Accepted solution]

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.