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

[GlennCossar]

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 😀

[GlennCossar]

Thank you so much - i will try this out as you have explained 🙂

[Anonymous · Accepted solution]

Hi @GlennCossar ,

Base on your description, it seems like you got errors when select multiple options for the parameter in the paginated report. Could you please provide the error details(error message and screenshot)? And please check and confirm the following info?

1. Ensure the SQL query supports multiple values

WHERE FIELDNAME IN (@PARAMETERNAME)

2. Ensure the parameter be set as "Allow multiple values"

Report parameters in Power BI Report Builder - Power BI | Microsoft Learn

Add a multi-value parameter to a paginated report - Power BI | Microsoft Learn

Power BI Report Builder Parameters Tutorial – SQLServerCentral

Best Regards