how to assign dynamically the value of a column to a parameter

[vyv]

Hello everyone.
Hope someone can help please.
I have a dataflow with a table that has a single record and I need to assign the value of a unique column, dynamically, to a parameter.
In the definition of the parameter, I configured it to be based on that query but I couldn't get it to take the value of the column after the query that feeds the table is executed.
Is anyone else having this issue and if so, have you managed to resolve it.
Thank you for your advice!

[vyv]

Hi @v-binbinyu-msft 

I need to do it in a dataflow, before reaching the dataset loading stage.

Best regards

[v-binbinyu-msft]

Hi @vyv ,

Please try to use Dynamic M query parameters in Power BI Desktop, hope it is helpful for you.

For more details, you could read related document: Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.