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
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.
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.
RE: Pass filters in URL
URL and JavaScript way: http://stackoverflow.com/questions/35555694/passing-parameters-to-power-bi-filter-programmatically
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
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.
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
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.
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.
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!
RE: Pass filters in URL
Please add soon, much needed to the full extent