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

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.

Thanks for your reply. I'll try to make it clearer. '...and THAT' meaning those chosen paramters need to be either be used against the imported data from SQL in Power bi, or run a SQL query in the SQL DB, in both cases display the results in Power bi.

Sorry, but this did not help me understand what you are trying to do. Can you show us a picture of what this means:

"I have drop down lists from imported SQL data tables"

What is in this data? Names of tables? Or actual table data?

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.

'You must first load data via the Power Query (queries) before an visuals will render in Power BI' - I loaded SQL tables into Power in a slicer format

and wish that the state picked will be used as a parameter to query another table that was also loaded in power.

.