Dynamic Query Parameters in SQL query.

Hello rnola16 ,

Yes , using parameters you can control what data you want to load and can utilize additional slicers/filters for your report. 

I would suggest to create a procedure with inputs (Case_ID in your case ). You can pass Min_Case_ID and Max_Case_ID parameters  to filter your query in stored procedure and use this stored procedure to load data in power bi. This way you have better control and you can apply additional logics and performance optimization if required.

Steps :

1. Create procedure with parameters to filter data 

2. Create power bi parameter and use in this procedure

Example :

EXEC GetFilteredData @Min_Case_ID = 1000, @Max_Case_ID = 500000

I hope this helps.

Did I answer your query ? Mark this as solution if this helps , Kudos are appreciated.

Warm Regards,

Neeraj