Error on PBI Report Builder that works in SSRS

[Mark_Adams]

I'm using PBI Report Builder for the first time but have experience with SSRS Report Builder. I linked to a data source and then added a dataset with no parameters and that worked. I then added a dataset with date parameters (straight copy and paste from a working SSRS report). This runs fine in Query Designer after prompting me to type in dates..

Parameters as here

WHERE
(
Child_Social.FACT_CLA.START_DTTM BETWEEN @StartDate AND @EndDate
AND etc.

The parameters in the report have been set to date format and then in Available Values I've set the relevant date fields from the dataset. When I try to run the report I get this error:

The 'Value' expression for the query parameter '' refers to a non-existing report parameter 'Parameter3'. Letters in the names of parameters must use the correct case.
----------------------------
The definition of the report '' is invalid.
----------------------------
An error occurred during local report processing.

Any idea what I'm missing please? Do parameters works differently in PBI.

Thanks in advance

[bradsy · Accepted solution]

If the parameter is used in the query, you need to also add the parameter to the dataset. In both versions of report builder, you can check the properties on the dataset. Right click the dataset in the Report Data pane, look for the tab called parameters. These are specific to the dataset which are different then report parameters. Duplicate the mapping between the two should work.

[Mark_Adams]

I had tried this but the error persisted. However, I've tried a new report from scratch with the same SQL and it is working now. I don't know what the cause was but it is sorted. Thanks for your help.