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

v-qiuyu-msft's avatar
v-qiuyu-msft
Community 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
    Resolver 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:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Here is my version:

      Seems like you have a more reacent version. Will try to download and install the latest version.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Now I have the latest version of the server installed and still unable to filter. I have now tested to import a small table and filtered on that. Nothing works! In Chrome...

         

        I really need this feature for ALL browsers!

         

        Report ServerQuery Editor