cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

URL FIlter is not workin in Power BI Report Server

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!!2020-10-07 10_36_20-Microsoft Edge.png

1 ACCEPTED SOLUTION
Community Support
Community Support

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.

View solution in original post

7 REPLIES 7
Frequent Visitor

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. 

Community Support
Community Support

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.

View solution in original post

Solution Specialist
Solution Specialist

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). 

 

20201008172731.png

 

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

 

Good luck!

Super User III
Super User III

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

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

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

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

 

The % encodings is automatic generated after running the URL.

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.