cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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!

1 ACCEPTED SOLUTION

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

View solution in original post

8 REPLIES 8
muchinski
Resolver II
Resolver II

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
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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?

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:

 

Version.PNGVersion2.PNG

Anonymous
Not applicable

Here is my version:

2017-11-07 10_42_04-Test2 - Power BI Report Server.png

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

Anonymous
Not applicable

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 ServerReport ServerQuery EditorQuery Editor2017-11-07 11_23_36-Test2 - Power BI Report Server - Internet Explorer.png

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

Anonymous
Not applicable

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.