Skip to main content

Power BI

Needs Votes

When Power BI is embedded into SharePoint, allow filters to be preset

Vote (201) Share
Jeremiah's profile image

Jeremiah on 09 Dec 2016 03:01:20

It is currently possible for filters (or even slicers) to be preset when publishing to PowerBI.com. From a threat on the recent PBI AMA it was stated that Power BI will be able to be embedded in SharePoint. When that happens, it would be great to be able to preset filters for each embedded dashboard/report rather than needing to set it in the Power BI pbix file first. This way it would allow multiple instances of the dashboard/report to be embedded and filters set for the specific SharePoint embed locations. The use case for this could be a sales situation where there are multiple sales regions all looking at the same report. It would be nice to have the report embedded in each of their team sites and pre-filtered to their region.

Comments (16)
Jeremiah's profile image Profile Picture

Yorick De Rijck on 17 Jan 2024 08:48:24

RE: When Power BI is embedded into SharePoint, allow filters to be preset

Hi all ! What is the last status with regards to this topic ? Thanks!

Jeremiah's profile image Profile Picture

Preston Leigh on 21 Feb 2023 23:24:47

RE: When Power BI is embedded into SharePoint, allow filters to be preset

It is surprising that this is not a default feature

Jeremiah's profile image Profile Picture

Ryan Dawe on 21 Jun 2022 16:25:07

RE: When Power BI is embedded into SharePoint, allow filters to be preset

Please get onto this, it's so cumbersome trying to set up for a meeting without this feature.

Jeremiah's profile image Profile Picture

christophe chopin on 20 May 2022 19:51:27

RE: When Power BI is embedded into SharePoint, allow filters to be preset

This is a very important enhancement for us to be considered by Microsoft. We get around 53 SharePoint sites. For all, the exact same data structure. Instead having 53 report copies, we would be much more productive having only one copy, filtered by SharePoint site.

Jeremiah's profile image Profile Picture

Christian Winheller on 06 Oct 2021 12:49:20

RE: When Power BI is embedded into SharePoint, allow filters to be preset

Please enable this feature. See also Microsoft Idea · Personal view - https://ideas.powerbi.com/ideas/idea/?ideaid=f3644fbe-fac5-422b-b4a0-fbe68e675f96

Jeremiah's profile image Profile Picture

Aaron M on 02 Feb 2021 16:23:02

RE: When Power BI is embedded into SharePoint, allow filters to be preset

This would be very helpful. Right now I am going to have to create many reports filtered for each area.

Jeremiah's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:52

RE: When Power BI is embedded into SharePoint, allow filters to be preset

I have 300 projects, with 300 SharePoint site pages and 300 PowerBI embeded Report!!!
This would be a great idea!
I have PowerBI Premium.

Jeremiah's profile image Profile Picture

Adam Pope on 06 Jul 2020 00:00:36

RE: When Power BI is embedded into SharePoint, allow filters to be preset

We've a report we'd like to embed on 43 site pages with a filter to that site's community. Because there's no ability to do so, we need to recreate the report 43 times and we know we're likely to have many requests for improvements to that report; which we'll then have to reproduce 43 times.

As there's no way to filter to a URL in the sharepoint embed, or create a template in Power BI that will force updates to all reports in the file (like Dreamweaver does on a set of webpages for instance) leadership are investigating alternative options for providing these reports, and opinion on Power BI is that it's great for some things, but fails at the final hurdle.

Jeremiah's profile image Profile Picture

Mark Eckert on 05 Jul 2020 23:37:51

RE: When Power BI is embedded into SharePoint, allow filters to be preset

this is desperately needed, should be standard functionality. instead its an impediment with using the service and its integration. 2 years and no progress on this.

Jeremiah's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:36:13

RE: When Power BI is embedded into SharePoint, allow filters to be preset

I agree with other comments. We have many reports we would like to embed in SharePoint where report context on page is intended for a single audience. The only alternative option right now would be to create a pre-filtered report for each audience but O&M overhead with such an approach is not feasible.