The url query filter feature adds a report filter instead of changing the existing one

[Willgart]

I have a report with a report level filter in place: "SalesOrderID"

I call the report using an URL with a filter apply:

?filter=Sales/SalesOrderID eq 'mynewid'

this action adds a filter in the report which falls in conflict with the existing one, instead of changing the filter in place to the value from the URL.

[v-haibl-msft]

@Willgart

I can repro the same issue as you. I’ve reported it internally to Power BI Team: CRI 34809032
I’ll post here once I get any update about it.

Best Regards,
Herbert

[v-haibl-msft]

@Willgart

I've got response from the Product Team.

This is a by design. URL Filters are added as AND condition to the current report level filters. It is up to the report author to match and align the filters with desired behavior.

Best Regards,
Herbert

[Willgart]

by design????

its just a bug! not a feature!!!

The Power BI dev team was smarter than this in delivering features.

I hope you'll correct this BUG in a next release.

[v-haibl-msft]

@Willgart

I've also sent mail to the product team to see if it is possible to have a design change. You can also create an idea in https://ideas.powerbi.com for it.

Best Regards,
Herbert

[Willgart]

thanks for the quick feedback 🙂

you have a great tool in your hand... make it a killer tool!!! 🙂

[daniels]

has someone tried url filtering with power bi hosted on premise on SSRS 2016?