70-339 · Question #100
You have an on-premises SharePoint 2016 environment. You want to use Power View and PowerPivot features including Power View reports that are embedded in Microsoft Excel workbooks. You need to…
The correct answer is B. Install SQL Server 2016 Reporting Services (SSRS) in SharePoint integrated mode. C. Install an Office Online server. Enabling Power View and PowerPivot features in SharePoint 2016 requires SQL Server Reporting Services in SharePoint integrated mode and Office Online Server.
Question
You have an on-premises SharePoint 2016 environment. You want to use Power View and PowerPivot features including Power View reports that are embedded in Microsoft Excel workbooks. You need to deploy the new features. Which two actions should you perform? Each correct answer presents part of the solution.
Options
- AInstall PerformancePoint Services.
- BInstall SQL Server 2016 Reporting Services (SSRS) in SharePoint integrated mode.
- CInstall an Office Online server.
- DInstall SQL Server 2016 Reporting Services (SSRS) in native mode.
How the community answered
(42 responses)- A14% (6)
- B79% (33)
- D7% (3)
Why each option
Enabling Power View and PowerPivot features in SharePoint 2016 requires SQL Server Reporting Services in SharePoint integrated mode and Office Online Server.
PerformancePoint Services provides KPI dashboards and scorecards and has no role in enabling Power View or PowerPivot functionality.
SQL Server 2016 Reporting Services in SharePoint integrated mode is required because Power View is delivered as an SSRS feature and must be configured in SharePoint integrated mode to render Power View reports directly within SharePoint pages and document libraries.
Office Online Server is required to render Power View reports embedded in Excel workbooks, as it handles the in-browser rendering of Excel content including embedded Power View sheets when accessed through SharePoint.
SSRS in native mode operates as a standalone report server independent of SharePoint and cannot integrate with SharePoint to deliver Power View reports within the SharePoint user interface.
Concept tested: Deploying Power View and PowerPivot in SharePoint 2016
Source: https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services-sharepoint-mode
Topics
Community Discussion
No community discussion yet for this question.