M query dynamic parameter-new

[Ellenwan]

Hi,

I have premium license with June 2024 desktop version. I only created a new parameter, a table with one column which included possible value in the parameter. however, I still can't find Binding to parameter for the field in the table property advanced. Have this issue been resolved? I have removed all possible factors that may have impact on having this feature.

thanks

[lbendlin · Accepted solution]

You are mixing two separate concepts.  Unfortunately they are both called "Parameters",  but the one you created is called "Field Parameter"  and is only valid inside of DAX.  What you need is a Power Query Parameter that you then need to include in your Power Query code, and bind to a column in the data model.

[Anonymous · Accepted solution]

Hi @Ellenwan ,

@lbendlin ,Thank you for the detailed explanation!
And @Ellenwan , You can refer to this document for the implementation steps:
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

There are also a couple of points I need to add:
The Dynamic M query parameter is only available in DirectQuery mode, not Import or Live Connection.
The Dynamic M query parameter also has a number of limitations that may prevent you from succeeding if your data or operation involves these limitations:
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn


Best Regards,
Dino Tao
If this post helps, then please consider Accept both of the answers as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

You are mixing two separate concepts.  Unfortunately they are both called "Parameters",  but the one you created is called "Field Parameter"  and is only valid inside of DAX.  What you need is a Power Query Parameter that you then need to include in your Power Query code, and bind to a column in the data model.