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
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

 

2 REPLIES 2
v-denglli-msft
Community Support
Community Support

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

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.