Dynamic Power query

[ChnYasAns]

I need your support to show me how to pass parameters to a sql query and then launch it by cliking on a button in a power BI report. That means, the query will get data after considering the filters choosen by an user.

[v-jianboli-msft · Accepted solution]

Hi @ChnYasAns ,

Please try:

First create a parameter that you want to pass to the data source:

Then connect your parameter to your data source like this:

Then create a Parameter table in the data model and bind to parameter:

Now you can use this value to create a slicer that can change your data source:

Note:  Dynamic M query parameters  (Bind to parameter option) is only available for some Direct Query source.

Please refer to this:

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.