topic Re: URL FIlter is not workin in Power BI Report Server in Report Server

URL FIlter is not workin in Power BI Report Server

Anonymous — Wed, 07 Oct 2020 01:41:15 GMT

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

Re: URL FIlter is not workin in Power BI Report Server

lbendlin — Wed, 07 Oct 2020 17:19:19 GMT

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-in-url-filters

Re: URL FIlter is not workin in Power BI Report Server

Anonymous — Wed, 07 Oct 2020 23:27:43 GMT

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

Re: URL FIlter is not workin in Power BI Report Server

lbendlin — Wed, 07 Oct 2020 23:43:02 GMT

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

Re: URL FIlter is not workin in Power BI Report Server

Anonymous — Wed, 07 Oct 2020 23:55:40 GMT

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

The % encodings is automatic generated after running the URL.

Re: URL FIlter is not workin in Power BI Report Server

DavisBI — Thu, 08 Oct 2020 09:37:49 GMT

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!

Re: URL FIlter is not workin in Power BI Report Server

Anonymous — Wed, 14 Oct 2020 00:02:55 GMT

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.

Re: URL FIlter is not workin in Power BI Report Server

Icey — Fri, 23 Oct 2020 06:09:03 GMT

Hi Anonymous ,

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.

Re: URL FIlter is not workin in Power BI Report Server

Mukul227 — Tue, 30 May 2023 10:30:40 GMT

Hi, I am unable to use this filter,

https://app.powerbi.com/reportEmbed?reportId=7cd067fc-2180-4001-93fe-bc1b2bd4c15d&autoAuth=true&ctid=e0b26355-1889-40d8-8ef1-e559616befda&$filter=Account/Sub_Segment__c in ('Shipper')