Forum Discussion
How to pass arguments in Power Bi query at runtime Dynamically
We have a query which has countryname and code. We want to pass the values to the query at runtime dynamically.
Any idea how can this be achieved?
Hi Harshi_09 ,
You can extract each column from the query as a new list and create parameters to use them in a new query.
This video introduces use parameters in a query that you can refer:
Populate a Power BI parameter list using a query
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hello - please post a sample of your query/script/screenshots, etc. so that we can better help.
Hi Harshi_09 ,
You can extract each column from the query as a new list and create parameters to use them in a new query.
This video introduces use parameters in a query that you can refer:
Populate a Power BI parameter list using a query
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
