Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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!
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.
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsMarch 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
139 | |
70 | |
67 | |
52 | |
52 |
User | Count |
---|---|
210 | |
92 | |
64 | |
59 | |
56 |