Forum Discussion
Solved
Advance option is not there for the column while using Dynamic M query Parameter
I am using a blank query to get data from an API endpoint. I am using a parameter in the query and it is working fine. Now I want to make it dynamic so that it can be changed with a slicer. The slice...
Not clear to me what you mean. Can you please elaborate?
lbendlin
Super User
Super UserNow I want to make it dynamic so that it can be changed with a slicer. Dynamic MQuery Parameters only work with Direct Query data sources. Your API data source is Import Mode and that won't work.
Yes, I know that. Is there any other way I can use slicer selection in direct query? We can use table data in the power query that's why I was wondering if there are any workaround for this
- lbendlin
Not clear to me what you mean. Can you please elaborate?