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
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
Solution SageSince 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