Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Power bi reports using parameters to create SQL queries and displaying the results.

Hi, I have drop down lists from imported SQL data tables to choose parameters in Power bi. I would like to place these parameters in a SQL query to query the tables or send the parameters back to SQ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi,

Thanks for the solution ToddChitt  offered, and i want to offer some more information for user to refer to.

hello Anonymous , based on your descriotion, you can consider to use dynamic paramater in power query, it can be used in power bi desktop so that can affect the query, but it can be used when the connection mode is direct query. You can refer to the following link about it.

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

And you can refer to the following sample 

Pass Parameters to SQL Queries - Excelguru

 

Best Regards!

Yolo Zhu

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

 

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
1 year ago

Anonymous Thanks for those links. I was not aware of this feature, of binding a field to a parameter. Do you know when the introduced that feature? It's so hard to keep up with the changes.