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)
This would be very helpful!
We would like to filter a Power BI Report (Power BI Report Server on our Premises) by passing the parameters somehow. Power BI online is not an option for us.
It would be great if we could pass a parameter in the URL. If there is another way to do so please advise.
RE: Pass filter in URL (Power BI Report Server)
This is very important feature existing even in SSRS. Do you have any estimation on release date? Currently it's showstopper for us to start migration from SSRS to PowerBI server.
RE: Pass filter in URL (Power BI Report Server)
Any news about this?
RE: Pass filter in URL (Power BI Report Server)
Yes please!!! it would be fantastic !!
RE: Pass filter in URL (Power BI Report Server)
Is there a planned release date for this feature? This would be very helpful!
RE: Pass filter in URL (Power BI Report Server)
Thanks for planning for this feature.
RE: Pass filter in URL (Power BI Report Server)
Yes it's important
RE: Pass filter in URL (Power BI Report Server)
Q1- Can i filter to report with query string in on-premises
Q2- How to create Dashboard in on-premises
RE: Pass filter in URL (Power BI Report Server)
It is an important feature
RE: Pass filter in URL (Power BI Report Server)
please do it, thx!