topic Re: Filter report with URL query paramaters in Report Server

Filter report with URL query paramaters

Anonymous — Mon, 06 Nov 2017 08:10:39 GMT

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!

Re: Filter report with URL query paramaters

v-qiuyu-msft — Tue, 07 Nov 2017 06:05:02 GMT

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

Re: Filter report with URL query paramaters

muchinski — Tue, 07 Nov 2017 08:54:47 GMT

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.

Re: Filter report with URL query paramaters

Anonymous — Tue, 07 Nov 2017 09:14:41 GMT

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?

Re: Filter report with URL query paramaters

muchinski — Tue, 07 Nov 2017 09:32:58 GMT

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:

Re: Filter report with URL query paramaters

Anonymous — Tue, 07 Nov 2017 09:55:45 GMT

Here is my version:

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

Re: Filter report with URL query paramaters

Anonymous — Tue, 07 Nov 2017 10:25:24 GMT

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

Re: Filter report with URL query paramaters

muchinski — Tue, 07 Nov 2017 11:05:22 GMT

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

Re: Filter report with URL query paramaters

Anonymous — Tue, 07 Nov 2017 12:15:52 GMT

Clearing the cache in Chrome did the trick! Thanks @muchinski