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
ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
1 year ago

Let em get this straight: You must first load data via the Power Query (queries) before an visuals will render in Power BI report pages. And on those pages you want to have the user be able to select a parameter and THAT changes how the queries behave, that have ALEADY run?

Did I understand that correctly?

Can't be done.

Maybe you can use Parameters in Power Query, where you can inject those values into the individual queries with simple transformation steps like filtering, etc.