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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.