Forum Discussion
Dynamic M Query Parameter
Hello All,
I want to pass my Slicer filter directly to SQL source in power BI using Dynamic Parameter.I created two parameter but the Binding to paramter option is not showing in the Modelling tab. Could you please help on this how to modify the M query and how to get the Parameter binding option .Below is the sample SQL query and i used direct query mode only
SELECT * FROM Table
WHERE
"Application_ID" = 'PIC' AND
"BuName" = 'BU'
Since you are not importing your data in Direct Query, the approach will work. However, if you prefer Dynamic M Parameters, this article shows a relevant example of how to do it.
Power BI Dynamic M Query Parameters – Debbies Microsoft Power BI, SQL and Azure Blog (home.blog)
Note, another option would be to add Filter steps in your query (instead of using a native query) for those fields and use the parameters there (and still bind them).
Pat
3 Replies
This is possible but why not just connect with Direct Query with no native query, and use slicers for those two columns on your page. The selected values will be passed back as filters to your source.
Pat
Since you are not importing your data in Direct Query, the approach will work. However, if you prefer Dynamic M Parameters, this article shows a relevant example of how to do it.
Power BI Dynamic M Query Parameters – Debbies Microsoft Power BI, SQL and Azure Blog (home.blog)
Note, another option would be to add Filter steps in your query (instead of using a native query) for those fields and use the parameters there (and still bind them).
Pat