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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
sobaig
Frequent Visitor

Error when trying to filter using URL parameter syntax

I am currently trying to filter a report using the URL parameter syntax. Currently, it works for one of the data fields but not the field that I need to filter by. Both are present in the report, and I know that the syntax is correct because it works for one of the fields.

 

The error when I try to filter using the URL Parameter Syntax is this: This field was deleted from the model and can't be used as a filter. What might be the issue? I have tried to debug but have not found a solution. Thanks!

 

sobaig_0-1728023549480.png

 

6 REPLIES 6
altesa
New Member

I'm having the same error, although the table and the field exist in my model. Have you found a solution?

Hi @altesa ,

 

Sorry for returning with the same solution, but have you tried removing and readding the filter?

 

Usually when this occurs means that you have deleted that specific value and in my experience even when you delete a column and then readd it it will make the specific filter work because it's based on names and not on ids of columns.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Gracias Miguel!

In fact, it worked when I've renamed the columns in my filters to avoid underscores. Also, I've switched to ID fields that I converted to numbers first, to avoid using single quotes. I had tried to replace those characters with url codes, and the resulting url looked Ok, but I couldn't make it work with strings...

Thaks for your help!

No problem, since Power BI uses naming convention to identify everything in a report visualization and filtering sometimes it gets tricky specially when you do the renaming of the fields.

 

Glad you were able to solve it.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

Thanks for the reply from @MFelix , please allow me to provide another insight.
Hi @sobaig ,

The following is a sample query URL.
URL?filter=Table/Field eq 'value'


1. Please check if the field represented by the Field parameter exists in the Table represented by the table parameter.

If the Field parameter does not match the Table parameter the problem you are experiencing will occur.


2. This issue will be encountered when the table represented by the Table parameter does not exist in the semantic model, please check this.


3. Table and Field names are case-sensitive. Please check for any spelling errors.

Best Regards,
Dengliang Li

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

MFelix
Super User
Super User

Hi @sobaig ,

 

In this case it seems like the specific field identified on the filter pane is deleted or renamed from the semantic model, I would remove that filter and readd it to the filter pane to see if it works.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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