Pass filter in URL (Power BI Report Server)
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)
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:
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.
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?
This is good, but I need it to work in publish to web URLs as well. Should I open a new idea?
Thank you! :)
Cool - thank you!
When this will be released with Power BI Report Server?
I have tried the latest version, it does not work.
Need this feature ASAP
Prashant Singh commented
@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.
Megerle Friedel commented
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.
Martin Larsson commented
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.
I miss this feature very much!
We need this feature.
Nikos TOMADAKIS commented
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.
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.
Any news about this?
Yes please!!! it would be fantastic !!
Is there a planned release date for this feature? This would be very helpful!
Thanks for planning for this feature.
Yes it's important
Metin SEVİNDİK commented
Q1- Can i filter to report with query string in on-premises
Q2- How to create Dashboard in on-premises
It is an important feature