Why do I need to create a new Dataset in Power BI Report Builder when creating a parameter?

[HamidBee]

I was watching a Microsoft Tutorial on Power BI Report Builder. The tutor created a new dataset before creating the parameter. This can be seen below at 03:14 :

https://www.youtube.com/watch?v=13-6sWIRD74&list=PL1N57mwBHtN1icIhpjQOaRL8r9G-wytpT&index=13

I noticed that if I create the parameter by using the same dataset as the one which contains the values I get the following error:

The report parameter 'Parameter' has a DefaultValue or a ValidValue that depends on the report parameter "Parameter". Forward dependencies are not valid.
----------------------------
The definition of the report '' is invalid.
----------------------------
An error occurred during local report processing.

 

But if I create a duplicate dataset (querying data from the same table) it works.

 

The duplicate data here would be in DataSet2. So I would assingn the ID from DataSet 2 as my parameter values which would filter through the values in DataSet1. Does anyone know why this is?.

Thank you

[duncfair]

I have the same error when creating a paginated report from a SQL Server parameterized stored procedure and there are no cascading scenarios in my report. The parameter was created automatically but does not work and returns the same error as above.

[v-zhangti · Accepted solution]

Hi, @HamidBee 

This is because this is the step for setting the cascading parameters. Cascading parameters are report parameters with dependencies. When a report user selects a parameter value (or values), it's used to set available values for another parameter.

Please refer to the following document, hope it can help you.

https://docs.microsoft.com/power-bi/guidance/paginated-report-cascading-parameter 

https://community.powerbi.com/t5/Desktop/How-do-I-filter-the-second-parameter-based-on-the-first/m-p... 

https://community.powerbi.com/t5/Desktop/Parameter-using-query-is-not-working-power-bi-report-builde... 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.