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)
i have a report in both Service and Server, and i applied same URL filter with 'in' operator, it works for Service report but not for Report Server. any idea?
RE: Pass filter in URL (Power BI Report Server)
It is not possible to filter a date with gt(greather) or lt(less than)?
RE: Pass filter in URL (Power BI Report Server)
Ne fonctionne pas pour moi non plus.
RE: Pass filter in URL (Power BI Report Server)
FYI people, UNDERSCORES in table names/column names DOES NOT WORK
RE: Pass filter in URL (Power BI Report Server)
Does not work for me either. I tried with Power BI Report Server March 2018 version and the data come from MDX queries
RE: Pass filter in URL (Power BI Report Server)
Please confirm if OR clause/Multi select of filter is supported? If not when we can expect this?
RE: Pass filter in URL (Power BI Report Server)
Does not work for me either.....they need to reopen this one
RE: Pass filter in URL (Power BI Report Server)
Also not working for me... ;( Power BI Desktop March 2018, is this a bug?
RE: Pass filter in URL (Power BI Report Server)
This worked for me with URL encoding.
RE: Pass filter in URL (Power BI Report Server)
I have Power Server March 2018 version. this is not working for me.