Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
triseid
Frequent Visitor

How to remove a parameter? (PowerBI Report Builder)

Hi,

 

I'm working in PowerBI Report Builder. Whenever I try to delete a parameter and then run my report, it says:

 

The Value expression for the query parameter ‘DeletedParameterName’ refers to a non-existing report parameter ‘DeletedParameterName’. 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 advice on removing parameters in a clean fashion? 

 

 

1 ACCEPTED SOLUTION

There are actually 2 types of parameters in paginated reports. There are "Report level parameters" and there are "Query level parameters". Normally when you create a parameter in your data set the designer creates a matching report level parameter and links the query parameter with the report parameter. It sounds like you have just deleted the report parameter without removing the query level parameter. 

 

If you right click on your dataset, go into properties you will see a parameters tab. You need to also remove your parameter from there and remove any references in your query (if you have not removed these already). This should fix your parameter error.

 

For the the DeletedRow issue my suggestion would be to open the reports rdl file in a text editor and search for "DeletedRow" text and see if you can find the reference there. I would not suggest making any edits in a text editor, just use it to locate where the deleted object is referenced, then go into the designer and remove the references.

View solution in original post

3 REPLIES 3
triseid
Frequent Visitor

On a similar note, same issue with deleting rows in a group. After I delete a grouped row it says 

 

'The grouping ‘ExistingRow’ has ‘DeletedRow’ as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and cannot be contained within the current report item unless current grouping scope has a Parent.
----------------------------
The definition of the report '' is invalid.
----------------------------
An error occurred during local report processing.

 

But when I look into properties, the 'toggle visibility' option is turned off. Cannot find mention of the deleted row anywhere. 

 

Thanks in advance!

There are actually 2 types of parameters in paginated reports. There are "Report level parameters" and there are "Query level parameters". Normally when you create a parameter in your data set the designer creates a matching report level parameter and links the query parameter with the report parameter. It sounds like you have just deleted the report parameter without removing the query level parameter. 

 

If you right click on your dataset, go into properties you will see a parameters tab. You need to also remove your parameter from there and remove any references in your query (if you have not removed these already). This should fix your parameter error.

 

For the the DeletedRow issue my suggestion would be to open the reports rdl file in a text editor and search for "DeletedRow" text and see if you can find the reference there. I would not suggest making any edits in a text editor, just use it to locate where the deleted object is referenced, then go into the designer and remove the references.

I had this same issue and the solution works but one thing that wasn't mentioned at least in my case ... was that the query-level parameter was hidden. I needed to right click the data set and show hidden data sets and there I found the parameters to delete.  

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.