It would be great if it would be possible to pass filters in the URL of the report on the report server (as it is already possible in Power BI online)
Administrator on 04 Nov 2017 06:56:16
As promised, we've added basic filtering of Power BI reports via URL parameters, similar to the Power BI service feature described here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-url-filters/. For example, if you’ve embedded a Power BI report into another app using an iframe and a URL like the following: https://reportserver/reports/powerbi/Store Sales?rs:Embed=true Then you can specify additional filters using the “filter” URL parameter: https://reportserver/reports/powerbi/Store Sales?rs:Embed=true&filter= Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct' Syntax: URL?filter=Table/Field eq 'value' 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.
- Comments (63)
RE: Pass filter in URL (Power BI Report Server)
Does this work for Power BI Report Server March 2018 version? I have been unable to get it to work.
RE: Pass filter in URL (Power BI Report Server)
my url query string is:
?rs:Embed=true&filter=product/productname eq 'abc'
I got an Error: Script error for "odataFilterParser".
any idea?
RE: Pass filter in URL (Power BI Report Server)
Thanks, can we also add auto refresh to the embed report (PowerBI report server) ?
RE: Pass filter in URL (Power BI Report Server)
Hi Riccardo, I upgraded PowerBI report server with the latest march update and basic filtering of Power BI reports via URL parameters doesn't work.
RE: Pass filter in URL (Power BI Report Server)
I Want Embedded report to web application,But the Pop-up box of User and Pwd is very Annoying,how can I do to Solve the problem
RE: Pass filter in URL (Power BI Report Server)
I upgraded PowerBI server with the Latest March release and the passing filters through URL is not working any more. It was working with October Release but not with the latest march release
RE: Pass filter in URL (Power BI Report Server)
It would be great to retrieve the current filter's state using JS API.
RE: Pass filter in URL (Power BI Report Server)
This feature is a must. we already use the eq= url filter but we need also to filter on multiple values of the same filed with OR is that possible? how?
RE: Pass filter in URL (Power BI Report Server)
How can we hide the filter pane and the worksheet pane? And preselect a worksheet?
RE: Pass filter in URL (Power BI Report Server)
The service feature document on microsoft.com says it is not supported on Power BI embedded but your example in above post says it does. Which one is true?