Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Filter report with URL query paramaters

I cannot get the newly added feature to filter reports through URL query paramters to work.

 

I have created a report with a manually entered table with the name Table1. Columns are Column1 and Column2. In these columns i enter the vauels (1, A), (2, B), (3, C) and (4, D). I add a simple table visual the show all rows from Table1. Then I pulish the report on my updated report server and enter the URL: http://server/reports/powerbi/TestReport?filter=Table1/Column1 eq 1. All lines are showing. I allso tried surrounding the 1 in single quotes but I get same result.

 

Help needed!

APIS and Embedding
  • muchinski's avatar
    muchinski
    8 years ago

    Hi Anonymous,

     

    I really dont know if that is the case, but I had some problems with visualizations that were solved after I cleaned the Chrome's browser cache.

     

    Filters here works with Chrome...

8 Replies

  • muchinski's avatar
    muchinski
    Icon for Resolver II rankResolver II
    8 years ago

    hello Anonymous,

     

    please be aware of the following limitations:

     

     

    The same restrictions that apply to the Power BI service apply to the Report Server as well:
    - Table and Field names are case sensitive, value is not.
    - Fields that are hidden from report view can still be filtered.
    - Value has to be enclosed with single quotes.
    - Field type has to be string.
    - Table and field names cannot have any spaces.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi Anonymous,

     

    The issue should be the Column1 data type is number, while it requires field to be string. You can filter via this URL:

    http://server/reports/powerbi/TestReport?filter=Table1/Column2  eq 'A'

     

    For more infomration, see: 

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19727650-pass-filter-in-url-power-bi-report-server

    https://powerbi.microsoft.com/en-us/documentation/powerbi-service-url-filters/

     

    Best Regards,
    Qiuyun Yu

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks but this did not solve the problem. I changed the name of the tabel to T and the columns to C1 and C2. Both columns are type text.

       

      I have tried this:

      http://rerver/reports/powerbi/TestReport?filter=T/C1 eq '1'

      http://rerver/reports/powerbi/TestReport?filter=T/C2 eq 'A'

      http://rerver/reports/powerbi/TestReport?filter=T/C2 eq 'a'

       

      Nothing seems to work. Im begining to doubt I have installed the latest version of PBI Report Server. How do I check that?

      • muchinski's avatar
        muchinski
        Icon for Resolver II rankResolver II
        8 years ago

        well, your sintax seems to be corect. I just tested in one of my reports and here it works well.

        You can check the version on the ? menu from the report portal: