Skip to main content
Microsoft Idea

Power BI

Completed

Pass filters in URL

Vote (2001) Share
Majhi Babu Gajula's profile image

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)
Majhi Babu Gajula's profile image Profile Picture

Jörgen Hasselgren on 05 Jul 2020 22:06:52

RE: Pass filters in URL

Great that it is planned, thanks

Majhi Babu Gajula's profile image Profile Picture

Adrian Theuma on 05 Jul 2020 22:06:48

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.

Majhi Babu Gajula's profile image Profile Picture

Keagan Lehmann on 05 Jul 2020 22:05:48

RE: Pass filters in URL

Hope this is implemented soon, should be standard functionality as it's so commonly used..!

Majhi Babu Gajula's profile image Profile Picture

Tomaž Silič on 05 Jul 2020 22:05:10

RE: Pass filters in URL

Why is this taking so long?

Majhi Babu Gajula's profile image Profile Picture

Zienab Allam on 05 Jul 2020 22:03:25

RE: Pass filters in URL

Definitely required

Majhi Babu Gajula's profile image Profile Picture

Power BI User on 05 Jul 2020 22:03:19

RE: Pass filters in URL

I definitely require this or else will need to go back to Reporting Services.

Majhi Babu Gajula's profile image Profile Picture

Jennifer Beckett on 05 Jul 2020 22:02:03

RE: Pass filters in URL

Has this been implemented in some fashion yet?

Majhi Babu Gajula's profile image Profile Picture

Wan Chi on 05 Jul 2020 21:59:26

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

Majhi Babu Gajula's profile image Profile Picture

Greg Newcom on 05 Jul 2020 21:59:01

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.

Majhi Babu Gajula's profile image Profile Picture

Power BI User on 05 Jul 2020 21:58:49

RE: Pass filters in URL

Must have feature, please implement! All reporting tools must have an option for entering in parameters.