cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.