Error when trying to filter using URL parameter syntax

[sobaig]

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!

[altesa]

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

[MFelix]

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.

[altesa]

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!

[MFelix]

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.

[Anonymous]

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]

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.