Forum Discussion
Dynamic M Query Parameter
my requirement i need to use Direct query mode only and the above SQL is sample only i have huge millions of data in my DB.Thats the reason I am planning to use dynamic M query Parameter
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
Solution SageThis 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