Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

URL Filters for on-premise reports

Hi All, We have on-premise power bi reports, We wanted to filter with URL parameters. I have tried like below. But reports are not filtering based on values. Is the feature work with on-premise serve...
On-Premise
url parameter
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
6 years ago

This work on my May 2020 instance of PBIRS.

 

Anonymous wrote:

If we have space for table or field

 

It should be as per the instructions for special characters here https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-in-table-and-column-names where you use _x0020_ for a space. So something like the following should work.

 

http://Server/Report Folder/Report Name?rs:Embed=true&filter=COVID_x0020_Test/GroupCode eq 'CB'

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi d_gosbell,

     

    Your suggestion worked like a charm.

     

    I heard query string filtering only works with text data type. Is there any restriction for filtering with query string.

     

    Thank you

     kranthi

    • d_gosbell's avatar
      d_gosbell
      Icon for Super User rankSuper User
      6 years ago
      Anonymous wrote:

       

      I heard query string filtering only works with text data type. Is there any restriction for filtering with query string.

       

      No this is not true, I just filtered on a numeric column and it worked fine. I don't really use URL filtering much myself. I'd expect any limitations to be in the documentation like I posted previously.