Power Pivot for SharePoint (SSAS)Power Pivot for SharePoint (SSAS)

適用対象: ○SQL Server Analysis Services XAzure Analysis Services XPower BI PremiumAPPLIES TO: yesSQL Server Analysis Services noAzure Analysis Services noPower BI Premium

Analysis ServicesAnalysis Services モードの Power PivotPower Pivot サーバーは、SharePoint ファームの Power PivotPower Pivot データをサーバーでホストします。An Analysis ServicesAnalysis Services server in Power PivotPower Pivot mode provides server hosting of Power PivotPower Pivot data in a SharePoint farm. Power PivotPower Pivot データは、次のいずれかを使用して構築する分析データ モデルです。data is an analytical data model that you build using one of the following:

  • Power PivotPower Pivot for Excel 2010 アドインThe Power PivotPower Pivot for Excel 2010 add-in

  • Excel 2013Excel 2013

  • Excel 2016Excel 2016

適用対象:Applies to: Power Pivot for SharePointPower Pivot for SharePoint 2016 | Power Pivot for SharePointPower Pivot for SharePoint 2013適用対象:Applies to: Power Pivot for SharePointPower Pivot for SharePoint 2016 | Power Pivot for SharePointPower Pivot for SharePoint 2013

そのデータをサーバーでホストするには、SharePoint、Excel Services、および Power PivotPower Pivot for SharePoint のインストールが必要です。Server hosting of that data requires SharePoint, Excel Services, and an installation of Power PivotPower Pivot for SharePoint. Power PivotPower Pivot for SharePoint インスタンスにデータが読み込まれます。このデータは、 Power PivotPower Pivot データ更新機能を使用してスケジュール設定された間隔で更新できます。この更新機能は、Excel 2010 ブックの場合はサーバーによって、Excel 2013 と 2016 ブックの場合は Power PivotPower Pivot によって提供されます。Data is loaded on Power PivotPower Pivot for SharePoint instances where it can be refreshed at scheduled intervals using the Power PivotPower Pivot data refresh capability that the server provides for Excel 2010 workbooks, that the Power PivotPower Pivot provides for Excel 2013 and 2016 workbooks.

Power Pivot for SharePoint 2016Power Pivot for SharePoint 2016

SQL Server 2017SQL Server 2017 Power Pivot for SharePointPower Pivot for SharePoint サポートMicrosoftMicrosoftデータ モデルを含む Excel ブックの SharePoint 2016 と Office Online Server の使用状況とReporting ServicesReporting ServicesPower View レポートします。Power Pivot for SharePointPower Pivot for SharePoint supports MicrosoftMicrosoft SharePoint 2016 and Office Online Server usage of Excel workbooks containing data models and Reporting ServicesReporting Services Power View reports.

Office Online Server 内の Excel にはとの対話を有効にするためのデータ モデル機能が含まれています、Power PivotPower Pivotブラウザー内のブック。Excel, within Office Online Server includes data model functionality to enable interaction with a Power PivotPower Pivot workbook in the browser. ファームに Power PivotPower Pivot for SharePoint 2016 アドインを配置する必要はありません。You do not need to deploy the Power PivotPower Pivot for SharePoint 2016 add-in into the farm. のみをインストールする必要があります、Analysis ServicesAnalysis ServicesサーバーPower PivotPower Pivotモードと Office Online Server でサーバーを登録します。You only need to install an Analysis ServicesAnalysis Services server in Power PivotPower Pivot mode and register the server with Office Online Server.

Power PivotPower Pivot for SharePoint 2016 アドインを配置すると、SharePoint ファームで追加の機能を有効にすることができます。Deploying the Power PivotPower Pivot for SharePoint 2016 add-in enables additional functionality and features in your SharePoint farm. 追加の機能には、 Power PivotPower Pivot ギャラリーとデータ更新のスケジュールがあります。The additional features include Power PivotPower Pivot Gallery and Schedule Data Refresh.

SSAS Power Pivot モード 3 のサーバー Office Online Server でSSAS Power Pivot Mode 3 Server with Office Online Server

Power Pivot for SharePoint 2013Power Pivot for SharePoint 2013

SQL Server 2017SQL Server 2017 Power Pivot for SharePointPower Pivot for SharePoint は、 MicrosoftMicrosoft SharePoint 2013 Excel Services による、データ モデルと Reporting ServicesReporting Services Power View レポートを含む Excel ブックの使用をサポートします。Power Pivot for SharePointPower Pivot for SharePoint supports MicrosoftMicrosoft SharePoint 2013 Excel Services usage of Excel workbooks containing data models and Reporting ServicesReporting Services Power View reports.

SharePoint 2013 の Excel Services には、ブラウザーで Power PivotPower Pivot ブックを操作できるようにするためのデータ モデル機能が含まれます。Excel Services in SharePoint 2013 includes data model functionality to enable interaction with a Power PivotPower Pivot workbook in the browser. ファームに Power PivotPower Pivot for SharePoint 2013 アドインを配置する必要はありません。You do not need to deploy the Power PivotPower Pivot for SharePoint 2013 add-in into the farm. 必要な操作は、 Analysis ServicesAnalysis Services サーバーを SharePoint モードでインストールし、Excel Services の [データ モデルの設定] でサーバーを登録するだけです。You only need to install an Analysis ServicesAnalysis Services server in SharePoint mode and register the server within the Excel Services Data Model settings.

Power PivotPower Pivot for SharePoint 2013 アドインを配置すると、SharePoint ファームで追加の機能を有効にすることができます。Deploying the Power PivotPower Pivot for SharePoint 2013 add-in enables additional functionality and features in your SharePoint farm. 追加の機能には、 Power PivotPower Pivot ギャラリー、データ更新のスケジュール、および Power PivotPower Pivot 管理ダッシュボードがあります。The additional features include Power PivotPower Pivot Gallery, Schedule Data Refresh, and the Power PivotPower Pivot Management Dashboard.

SSAS PowerPivot モード 2 のサーバー配置SSAS PowerPivot Mode 2 Server Deployment

トピックの内容In This Section

サーバーの全体管理での Power Pivot サーバーの管理と構成Power Pivot Server Administration and Configuration in Central Administration

Windows PowerShell を使用した Power Pivot の構成Power Pivot Configuration using Windows PowerShell

Power Pivot の構成ツールPower Pivot Configuration Tools

Power Pivot の認証および承認Power Pivot Authentication and Authorization

Power Pivot の正常性ルールの構成Configure Power Pivot Health Rules

Power Pivot 管理ダッシュボードと使用状況データPower Pivot Management Dashboard and Usage Data

Power Pivot ギャラリーPower Pivot Gallery

Power Pivot データ アクセスPower Pivot Data Access

Power Pivot データ更新Power Pivot Data Refresh

Power Pivot データ フィードPower Pivot Data Feeds

Power Pivot BI セマンティック モデル接続 (.bism)Power Pivot BI Semantic Model Connection (.bism)

他のセクションIn other sections

その他のトピックAdditional topics

Power Pivot for SharePoint のアップグレードUpgrade Power Pivot for SharePoint

Power Pivot モードでの Analysis Services のインストールInstall Analysis Services in Power Pivot Mode

Power Pivot for SharePoint 用 PowerShell リファレンスPowerShell Reference for Power Pivot for SharePoint

SQL Server 2016 Business Intelligence のライセンスのトポロジおよびコストの例Example License Topologies and Costs for SQL Server 2016 Business Intelligence

関連項目See Also

Power Pivot Planning and Deployment (Power Pivot の計画と配置) Power Pivot Planning and Deployment
Disaster Recovery for Power Pivot for SharePoint (Power Pivot for SharePoint の災害復旧)Disaster Recovery for Power Pivot for SharePoint