Converting Crystal Reports to Power BI Report Builder - Dynamic parameter set up troubles

Hi everyone!

I’m struggling to figure this out and can't seem to make it work. I'm currently converting a large number of Crystal Reports to Power BI Report Builder, and here's the process I'm following:

1. Extract SQL from Crystal Reports
2. Refine the SQL (rename column headers, format dates, etc.)
3. Use the Table Wizard to create a table in Power BI Report Builder from the refined SQL
4. Update the page, table, font, borders, etc.

Everything works perfectly up to this point, and the report displays fine when I run it.

Now, I want to:

- Create dynamic parameters using some of the column headers, which should display only distinct results from the refined SQL in step 2 (e.g., I have a column called Sample with hundreds of distinct results in the unfiltered table, but the refined SQL significantly reduces these results when running the report).
- Allow the dynamic parameters to be used so the report can be run with parameter filters:
- Blank (show all results)
- Select one parameter (show all results for that one refined parameter based on the selected option from the available list)
- Select multiple options from one parameter (show all results for that refined parameter based on the selected options from the available list)
- Select one or multiple options from multiple parameters (show all results for the combination of parameters used based on the selected options from the available lists)

I have managed to set it up so that i get a filtered list and can select one item run the report and all is well. However when i select more than one it errors.

I have referred to every Youtube clip, used AI to assist and searched on multiple forums but can't get this going.

Any help would be greatly appreciated 😀