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

o365SPO on 05 Jul 2020 22:18:08

RE: Pass filters in URL

This is a must have feature at not just the dashboard level, but the report level. Couple that with a native SharePoint Web part with a query string parameter connector.

Majhi Babu Gajula's profile image Profile Picture

Shaker on 05 Jul 2020 22:17:05

RE: Pass filters in URL

Passing parameters via the URL isn't secure enough. We need a way to pass parameters that doesn't allow users to change the query string to see other user data.

Majhi Babu Gajula's profile image Profile Picture

Andrzej on 05 Jul 2020 22:16:49

RE: Pass filters in URL

URL and JavaScript way: http://stackoverflow.com/questions/35555694/passing-parameters-to-power-bi-filter-programmatically

Majhi Babu Gajula's profile image Profile Picture

Matthieu Maitre on 05 Jul 2020 22:16:12

RE: Pass filters in URL

Some filtering capabilities are available. Shameless plug: http://mmaitre314.github.io/2016/02/13/passing-report-filters-to-power-bi-using-urls.html

Majhi Babu Gajula's profile image Profile Picture

Scott M. Randolph on 05 Jul 2020 22:16:05

RE: Pass filters in URL

Any way to pass parameters to a Power BI report would be helpful. if URL is the only way, so be it. Been passing in parameters with SSRS, even Crystal Reports, so critical for us.

Majhi Babu Gajula's profile image Profile Picture

Power BI User on 05 Jul 2020 22:15:40

RE: Pass filters in URL

we want to implement advanced visualisations, based on data in an existing BI system, and add links to relevant data in powerBI dashboard. adding that capability will be very helpful

Majhi Babu Gajula's profile image Profile Picture

Vijayalakshmi S M on 05 Jul 2020 22:12:48

RE: Pass filters in URL

Here we want implement to power Bi reports in MVC web Application, I need particular report filter the as a Parameter.

Majhi Babu Gajula's profile image Profile Picture

Hua Yang on 05 Jul 2020 22:12:41

RE: Pass filters in URL

I think this is important. I want to embed a report in our e-commerce site, so each customer can see their own spending on the report. To achieve that we need pass a customer's credential as a filter to filter the data.

Majhi Babu Gajula's profile image Profile Picture

Bjoern on 05 Jul 2020 22:11:02

RE: Pass filters in URL

Would this also include the slicer selection or would it only be applicable for filters? Slicers are also very important!

Majhi Babu Gajula's profile image Profile Picture

Power BI User on 05 Jul 2020 22:08:09

RE: Pass filters in URL

Please add soon, much needed to the full extent