Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
pkn7
Frequent Visitor

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

1 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.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

3 REPLIES 3
danextian
Super User
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.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Hi @danextian ,

Is there a way to bind the slicer to paramCOUNTRY?

 

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.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.