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

meforst on 06 Jul 2020 00:00:56

RE: Pass filters in URL

I just want to be able to set the "parameter" values in the url
We can filter dashboards with URL parameters with ?filter
But I created a parameter on the dashboards and want to set the value of that parameter in the URL with ?parametername=parametervalue

I really don't understand why this isn't implemented. Having to set the value of that parameterin the report settings doesn't make sense?

Majhi Babu Gajula's profile image Profile Picture

Power BI User on 05 Jul 2020 23:32:04

RE: Pass filters in URL

hi great feature if that include bookmark in url paramter filter.

Majhi Babu Gajula's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:32:03

RE: Pass filters in URL

Best way is to pass parameters to bookmark !

Majhi Babu Gajula's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:26:54

RE: Pass filters in URL

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 for Power BI Embedded as well as Power BI Service.

Majhi Babu Gajula's profile image Profile Picture

Mark Eckert on 05 Jul 2020 23:24:58

RE: Pass filters in URL

Any update on this 'Pass filter to URL' issue

Majhi Babu Gajula's profile image Profile Picture

Arthur van Rijn on 05 Jul 2020 23:21:40

RE: Pass filters in URL

Hi Sirui Sun, please provide an update on this 'Pass filter in URL' item. It's in the planning for 18 months now. Is there a roadmap for this embedded feature ? Hope so, we have got many votes ! Regards from Amsterdam, Arthur

Majhi Babu Gajula's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:48

RE: Pass filters in URL

'+1, this is a key feature to make PowerBI reports integrated into automation workflow.

Majhi Babu Gajula's profile image Profile Picture

Terry Kowalyk on 05 Jul 2020 23:13:53

RE: Pass filters in URL

If planning is underway for this feature it would also be beneficial to have url filters that can be encrypted to ensure security around sensitive or customer reporting.

Majhi Babu Gajula's profile image Profile Picture

Vinny on 05 Jul 2020 23:09:46

RE: Pass filters in URL

This is very useful in SSRS so would be great to have in PowerBI also for the same reasons

Majhi Babu Gajula's profile image Profile Picture

Ryan R on 05 Jul 2020 23:09:13

RE: Pass filters in URL

It would be great if this worked on reports embedded through iframe.