URL FIlter is not workin in Power BI Report Server

[Guilligam]

Hi all, I am trying to filter my PBIRS report but it's not working. I am using the syntax ?filter=table/field eq 'value'. It looks like it is understanding the syntax, but it's not passing the value. It's returning the field I am trying to filtering with a caution sign and filtering is(all). 

PBRIS is on premise, I was wondering if that's why it is not working?

Cheers!!

[Mukul227]

Hi, I am unable to use this filter,

https://app.powerbi.com/reportEmbed?reportId=7cd067fc-2180-4001-93fe-bc1b2bd4c15d&autoAuth=true&ctid... in ('Shipper')

[Guilligam]

Thanks All. Apparently Power Bi doesn't support URL filter on premises. It looks like that the only solution is using Paginated Report.

I tested and it works fine. Hopefuly Power BI Report Server get URL filter as a option in the future. 

[Icey · Accepted solution]

Hi @Guilligam ,

Power BI Report Server does support URL filter. Try something like this:

https://reportserver/reports/powerbi/YourReport?rs:Embed=true&filter=Occurrence/Occurrence_x0020_Type eq 'Custody'

Reference: Filter a report using query string parameters in the URL

• Power BI Report Server also supports the ability to specify additional filters using the “filter” URL parameter. Here's an example of what the URL might look like in Power BI Report Server: https://reportserver/reports/powerbi/Store Sales?rs:Embed=true&filter= Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'

---

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DavisBI]

Hi, I noticed that "occurrence type" in your table is all "custody". It seems that filtering is OK, If not, you should give a counter example to prove that the filter fails (At least I didn't find any problems in the pictures you provided).

For me, PBIRS URL filtering is working (pic as  below). 

I think you can double check your filter URL and try again.

Good luck!

[lbendlin]

you need to escape Occurrence Type as

Occurrence_x0020_Type 

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-i...

[Guilligam]

Thanks for your reply, but your solution didn't work. I am having the same output. I am using pbirs version: 15.0.1103.232. Do you if there is any issues on that version?

Thanks

[lbendlin]

try without the percent encodings. Make sure that you spelled both the table name and the column name exactly.

[Guilligam]

I am trying that: ?filter=Occurrence/Occurrence_x0020_Type eq 'Custody'

The % encodings is automatic generated after running the URL.