Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

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)
Status: Completed
Comments
nishalit
New Member
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.
abc19
New Member
'+1
diet3rix
New Member
'+1
robert_jaksch
New Member
That would be awesome 🙂
mail61
New Member
Yes, do it!!!
salar_reshu
New Member
please do it, thx!
anton12
New Member
Yes we need this....
arndt_faulhaber
New Member
'+1
vogt_hannes
New Member
We need this too.
ndanjid
New Member
It is an important feature