Pass filter in URL (Power BI Report Server)

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.