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)
Hi,
I tested this today but it is not working using Power BI report on SSRS on premise. The &filter is totally being ignored. Should we update anything before?
RE: Pass filter in URL (Power BI Report Server)
This is good, but I need it to work in publish to web URLs as well. Should I open a new idea?
RE: Pass filter in URL (Power BI Report Server)
When this will be released with Power BI Report Server?
I have tried the latest version, it does not work.
RE: Pass filter in URL (Power BI Report Server)
Thank you! :)
RE: Pass filter in URL (Power BI Report Server)
Need this feature ASAP
RE: Pass filter in URL (Power BI Report Server)
'@Riccardo Muti When this feature is expected to be released.Power BI service is not an option for us.We are in great need for this feature.
RE: Pass filter in URL (Power BI Report Server)
Please tell us the estimated or release date, we need this in the next weeks.
When will Power BI Service be aligned with Power BI Report Server, now the Report Server is has less features than the Cloud Version, you con say it is the light Version of the cloud product. We are not allowed to put our data in the cloud so we run the local PBI Server.
When will you publish the next Version? The last Version was the August 2017 Prewiew, now we have the 24th October.
RE: Pass filter in URL (Power BI Report Server)
As mentioned before, this is a showstopper for us as well. The filer URL query schema that exist in the PBI service is a bit too specific to the data source. It would be better to be able to filter through a parameter which makes it much more flexible and it does not expose the internal data structure in the URL.
RE: Pass filter in URL (Power BI Report Server)
I miss this feature very much!
RE: Pass filter in URL (Power BI Report Server)
We need this feature.