Power BI
Needs VotesWhen Power BI is embedded into SharePoint, allow filters to be preset
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)
RE: When Power BI is embedded into SharePoint, allow filters to be preset
This would be really awesome, you can currently link to a report with filter context, e.g. ?filter=... the Sharpoint web part accepts the url if you add &filter=... to the end of it but currently has no effect. Would be great if we could filter the embedded apps the same way as you link to them with filter context.
RE: When Power BI is embedded into SharePoint, allow filters to be preset
This, or some other capability that achieves the same end, is a very important enhancement to consider. Without this, embedding a report in a SharePoint page means creating a bespoke report for each page whereas if we had the ability to simply pass a filter in the embed URL, we could reuse an existing common report.
RE: When Power BI is embedded into SharePoint, allow filters to be preset
It is VERY important to be able to share and publish our reports directly to ON PREMISES Sharepoint or Sharepoint Services, which comes free with IIS.
Most companies still have their Intranet configure on premises, on internal servers, so its much more important a feature that will allow us to publish to a local sharepoint server than a online sharepoint service.
RE: When Power BI is embedded into SharePoint, allow filters to be preset
Personal dashboards in Sharepoint/CRM based on user identity.
Common report/dashboard based on context of embedded report/dashboard.
...
Many nice usecases for such ability.
Also allowing on-prem sources to be embedded in CRM/Sharepoint would be good. As per now, even though users have pro licenses, the on-prem sources needs to be accessed through the portal or PowerBI app for mobile devices.
RE: When Power BI is embedded into SharePoint, allow filters to be preset
This would be a great addition. I was asked a couple of days ago by my Chief Exec if this kind of thing was possible, so would be good to be able to say 'not yet but soon'
RE: When Power BI is embedded into SharePoint, allow filters to be preset
Yes please!