In addition to viewing Power BI reports in the web portal, Power BI Report Server can host Excel workbooks by using Office Online Server (OOS). Your report server becomes a single location to publish and view self-service Microsoft BI content.
Prepare server to run Office Online Server
Perform these procedures on the server that will run Office Online Server. This server must be Windows Server 2012 R2 or Windows Server 2016. Windows Server 2016 requires Office Online Server April 2017 or later.
Install prerequisite software for Office Online Server
Windows Server 2012 R2:
PowerShellCopy
Add-WindowsFeature Web-Server,Web-Mgmt-Tools,Web-Mgmt-Console,Web-WebServer,Web-Common-Http,Web-Default-Doc,Web-Static-Content,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Security,Web-Filtering,Web-Windows-Auth,Web-App-Dev,Web-Net-Ext45,Web-Asp-Net45,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Includes,InkandHandwritingServices,NET-Framework-Features,NET-Framework-Core,NET-HTTP-Activation,NET-Non-HTTP-Activ,NET-WCF-HTTP-Activation45,Windows-Identity-Foundation,Server-Media-Foundation
Windows Server 2016:
PowerShellCopy
Add-WindowsFeature Web-Server,Web-Mgmt-Tools,Web-Mgmt-Console,Web-WebServer,Web-Common-Http,Web-Default-Doc,Web-Static-Content,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Security,Web-Filtering,Web-Windows-Auth,Web-App-Dev,Web-Net-Ext45,Web-Asp-Net45,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Includes,NET-Framework-Features,NET-Framework-45-Features,NET-Framework-Core,NET-Framework-45-Core,NET-HTTP-Activation,NET-Non-HTTP-Activ,NET-WCF-HTTP-Activation45,Windows-Identity-Foundation,Server-Media-Foundation
If prompted, restart the server.
Install Office Online Server
If you plan to use any Excel Online features that utilize external data access (such as Power Pivot), note that Office Online Server must reside in the same Active Directory forest as its users as well as any external data sources that you plan to access using Windows-based authentication.
We recommend that you install Office Online Server on the system drive.
Install language packs for Office Web Apps Server (optional)
Office Online Server Language Packs let users view web-based Office files in multiple languages.
To install the language packs, follow these steps.
Deploy Office Online Server
Create the Office Online Server farm (HTTPS)
Use the New-OfficeWebAppsFarm command to create a new Office Online Server farm that consists of a single server, as shown in the following example.
PowerShellCopy
New-OfficeWebAppsFarm -InternalUrl "https://server.contoso.com" -ExternalUrl "https://wacweb01.contoso.com" -CertificateName "OfficeWebApps Certificate"
Parameters
Create the Office Online Server farm (HTTP)
Use the New-OfficeWebAppsFarm command to create a new Office Online Server farm that consists of a single server, as shown in the following example.
PowerShellCopy
New-OfficeWebAppsFarm -InternalURL "https://servername" -AllowHttp
Parameters
Verify that the Office Online Server farm was created successfully
After the farm is created, details about the farm are displayed in the Windows PowerShell prompt. To verify that Office Online Server is installed and configured correctly, use a web browser to access the Office Online Server discovery URL, as shown in the following example. The discovery URL is the InternalUrl parameter you specified when you configured your Office Online Server farm, followed by /hosting/discovery, for example:
Copy
<InternalUrl>/hosting/discovery
If Office Online Server works as expected, you should see a Web Application Open Platform Interface Protocol (WOPI)-discovery XML file in your web browser. The first few lines of that file should resemble the following example:
XMLCopy
<?xml version="1.0" encoding="utf-8" ?>
<wopi-discovery>
<net-zone name="internal-http">
<app name="Excel" favIconUrl="<InternalUrl>/x/_layouts/images/FavIcon_Excel.ico" checkLicense="true">
<action name="view" ext="ods" default="true" urlsrc="<InternalUrl>/x/_layouts/xlviewerinternal.aspx?<ui=UI_LLCC&><rs=DC_LLCC&>" />
<action name="view" ext="xls" default="true" urlsrc="<InternalUrl>/x/_layouts/xlviewerinternal.aspx?<ui=UI_LLCC&><rs=DC_LLCC&>" />
<action name="view" ext="xlsb" default="true" urlsrc="<InternalUrl>/x/_layouts/xlviewerinternal.aspx?<ui=UI_LLCC&><rs=DC_LLCC&>" />
<action name="view" ext="xlsm" default="true" urlsrc="<InternalUrl>/x/_layouts/xlviewerinternal.aspx?<ui=UI_LLCC&><rs=DC_LLCC&>" />
Configure Excel workbook maximum size
The maximum file size for all files in Power BI Report Server is 100 MB. To stay in sync with that, you need to manually set this in OOS.
PowerShellCopy
Set-OfficeWebAppsFarm -ExcelWorkbookSizeMax 100
Using EffectiveUserName with Analysis Services
To allow for live connections to Analysis Services, for connections within an Excel workbook that make use of EffectiveUserName. For OOS to make use of EffectiveUserName, you will need to add the machine account of the OOS server as an administrator for the Analysis Services instance. Management Studio for SQL Server 2016 or later is needed to do this.
Only embedded Analysis Services connections are currently supported within an Excel workbook. The user‘s account will need to have permission to connect to Analysis Services as the ability to proxy the user is not available.
Run the following PowerShell commands on the OOS Server.
PowerShellCopy
Set-OfficeWebAppsFarm -ExcelUseEffectiveUserName:$true
Set-OfficeWebAppsFarm -ExcelAllowExternalData:$true
Set-OfficeWebAppsFarm -ExcelWarnOnDataRefresh:$false
Configure a Power Pivot instance for data models
Installing an Analysis Services Power Pivot mode instance lets you work with Excel workbooks that are using Power Pivot. Make sure that the instance name is POWERPIVOT. Add the machine account of the OOS server as an administrator, for the Analysis Services Power Pivot mode instance. Management Studio for SQL Server 2016 or later is needed to do this.
For OOS to use the Power Pivot mode instance, run the following command.
PowerShellCopy
New-OfficeWebAppsExcelBIServer -ServerId <server_name>\POWERPIVOT
If you did not already allow external data, from the Analysis Services step above, run the following command.
PowerShellCopy
Set-OfficeWebAppsFarm -ExcelAllowExternalData:$true
Firewall considerations
To avoid firewall issues, you may need to open the ports 2382 and 2383. You can also add the msmdsrv.exe, for the Power Pivot instance, as an application firewall wall policy.
Configure Power BI Report Server to use the OOS Server
On the General page of Site settings, enter the OOS discovery url. The OOS discovery url is the InternalUrl, used when deploying the OOS server, followed by /hosting/discovery. For example, https://servername/hosting/discovery, for HTTP. And, https://server.contoso.com/hosting/discovery for HTTPS.
原文：https://www.cnblogs.com/Javi/p/13139919.html