Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic Power query

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.

Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Anonymous ,

     

    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.

1 Reply

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    3 years ago

    Hi Anonymous ,

     

    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.