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

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

RE: Pass filters in URL

Pleaae add, we use this currently with PowerBI in SharePoint, so it should still be supported in PowerBI

Majhi Babu Gajula's profile image Profile Picture

J Meyer on 05 Jul 2020 21:57:41

RE: Pass filters in URL

One of most importen feature for daly use. I want all my settings on the next day. If you want to save your analysis, it is now not possible to use this applikation, because if you have large organisations you need always to klick through the hole dimensions ( product hierarchie, customer hierarchie, costcenter hierarchie) if you like i can send you a solution - we have it implemented in arcplan. (public, privat bookmarks + sending to other people with all settings)
It helps a lot for daly business in firms.

see also bookmarks - if you have bookmarks, you can send them to a user.
It is the normal process of analysing
It is the same problem in sharepoint i cant save my anlytic settings !

Majhi Babu Gajula's profile image Profile Picture

Stacey Jones on 05 Jul 2020 21:57:29

RE: Pass filters in URL

Nice, but not on my top 10 list.

Majhi Babu Gajula's profile image Profile Picture

Bill logsdon on 05 Jul 2020 21:57:29

RE: Pass filters in URL

This is actually important for a loosely coupled reporting architecture. SSRS supports it now. Ideally, you want to be able to execute a report by passing in as arguments:
1) the name of the report
2) report filter parameters and their values
3) any formatting options

This allows a report to be called from another report as a drill down option, from any web front end, from a map (easy to construct a URL from ESRI), etc.

Your reports become independent building blocks that be easily assembled into solutions with minimal scripting or programming.

Majhi Babu Gajula's profile image Profile Picture

Jamie Thomson on 05 Jul 2020 21:57:29

RE: Pass filters in URL

Definitely need the ability to pass in parameters if reports are going to be embeddable. Furthermore its important that they are defined in the URL.

I wonder, if the user is accessing using their Azure Active Directory (AAD0 credentials might there be an opportunity to specify that the parameter should default to (say) their Windows login ID. In other words, the ability to default to a value from AAD