Embedded Report Url Filtering

[ceesvanegmond]

I'm applying a filter to an embedded report to ensure users only see the relevant project. The filter is provided in the following format: &filter=TABLE%2FProject_x0020_No_x0020_-_x0020_Title%20in%20(%27416033-54220%20-%20xx%27).

However, the data is still being filtered by the report's default filter. After inspecting the code in Chrome's DevTools, I noticed that two filters are being applied (as shown in the JSON below): the first is the default filter set by the report owner, and the second is the one applied via the URL.

Does anyone know how to resolve this, or should it be considered a bug?

"Where": [{
"Condition": {
"In": {
"Expressions": [{
"Column": {
"Expression": {
"SourceRef": {
"Source": "v"
}
},
"Property": "Project No - Title"
}
}
],
"Values": [[{
"Literal": {
"Value": "'412051-00155 - xxx'"
}
}
]]
}
}
}, {
"Condition": {
"In": {
"Expressions": [{
"Column": {
"Expression": {
"SourceRef": {
"Source": "v"
}
},
"Property": "Project No - Title"
}
}
],
"Values": [[{
"Literal": {
"Value": "'416033-54220 - xx'"
}
}
]]
}
}
}
]

[Anonymous]

Hi @ceesvanegmond ,

Thanks for @djurecic reply, that's really helpful!

@ceesvanegmond I recommend that you check that your URL filter is encoded correctly, and if you are going to use the in character, the parentheses should be a single column table separated by commas.Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

According to your URL filter, there is only one value in parentheses, so I recommend you use eq.

?filter=Table/ColumnName eq '416033-54220 - xx'

Best regards,

Mengmeng Li

[ceesvanegmond]

Thanks for the suggestion, I've used eq instead of in as well, that results in the same behavour.

[djurecic]

Hi @ceesvanegmond ,

 The URL filter will be applied in addition to any default filters from the report owner. I would try removing that default filter, then the URL filter should work as intended.