Majhi Babu Gajula on 26 Dec 2014 23:49:27
It would be great if we can pass filters in the url of the dashboard, which will filter the reports based on various parameters e.g. current fiscal period, geography, person's role, department etc.
Administrator on 26 Oct 2018 05:06:32
Thanks to everyone who participated in the filter survey last year and for leaving detailed comments below in the meantime as well. We used your feedback to prioritize and release two enhancements to our filtering: 1. In June, we released the ability to share report filters with others. Behind the scenes, this creates a bookmark with the current slicer/filter state and share a URL containing that bookmark ID. You can use that URL as you wish – in portals, your own emails, anywhere! 2. In August, we expanded support for URL filters on reports, by supporting additional data types (datetime), additional operators beyond equals (greater than or equals, greater than, less than or equals, less than), and the ‘in’ operator to allow filtering on multiple values easily. See more details at https://powerbi.microsoft.com/en-us/blog/power-bi-report-url-filter-improvements/ We hope these improvements have been helpful to you. If this wasn't enough and you still want other functionality, please vote on one of these ideas: - For filters on dashboards, which would pave the way for filtering through the URL: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6674820-global-filter-in-dashboards - For personal bookmarks: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31788253-personalized-bookmarks
- Comments (75)
RE: Pass filters in URL
Great that it is planned, thanks
RE: Pass filters in URL
I agree with the comments that this is a must have. Should also be available through the iPhone and iPad app in some form.
RE: Pass filters in URL
Hope this is implemented soon, should be standard functionality as it's so commonly used..!
RE: Pass filters in URL
Why is this taking so long?
RE: Pass filters in URL
Definitely required
RE: Pass filters in URL
I definitely require this or else will need to go back to Reporting Services.
RE: Pass filters in URL
Has this been implemented in some fashion yet?
RE: Pass filters in URL
I realy like the idea of passing filter via the URL. However web browsers have URL lenght limits. In the case of IE11 that is 2048 characters.
Whoever has tried passing filters into SSRS reports before should know how anoying the URL limitation can be (especially for multi value filters).
So, a big YES to passing filters into PowerBI and a very big NO for using the URL. Incorporate it into the API please
RE: Pass filters in URL
I definitely concur with passing parameters in the URL string. We do this extensively with SSRS. We have a .Net web app with a ReportViewer control that allows us to pass a user's federated login (SAML) attributes such as Role and organization to constrain data shown on the dashboards (row level security), and to enable/disable drill-thru permissions accordingly. We have a solution that is used statewide by school districts and the data is automatically filtered by the user's organizational credentials. We would love to take advantage of some of the Power BI features, but need this capability for deployment.
RE: Pass filters in URL
Must have feature, please implement! All reporting tools must have an option for entering in parameters.