Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Guilligam
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
Icey
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

8 REPLIES 8
Mukul227
Regular Visitor

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

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

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

lbendlin
Super User
Super User

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors