Power BI 报表服务器中 Power BI 报表数据源Power BI report data sources in Power BI Report Server

Power BI 报表可以连接不同的数据源。Power BI reports can connect to different data sources. 根据数据使用方式,可以提供不同的数据源。Depending on how data is used, different data sources are available. 可以导入数据,或者可以直接使用 DirectQuery 或与 SQL Server Analysis Services 的实时连接查询数据。Data can be imported or data can be queried directly using DirectQuery or a live connection to SQL Server Analysis Services.

这些数据源特定于 Power BI 报表服务器中使用的 Power BI 报表。These data sources are specific to Power BI reports used within Power BI Report Server. 有关分页报表支持的数据源的信息,请参阅 Reporting Services 支持的数据源For information about data sources supported with paginated reports, see Data Sources Supported by Reporting Services.

重要

若要配置计划的刷新,必须支持 Power BI Desktop 报表中的所有数据源。All data sources in a Power BI Desktop report must be supported to configure scheduled refresh.

受支持数据源的列表List of supported data sources

即使不在受支持列表中的其他数据源也可能有效。Other data sources may work even though they aren't on the supported list.

数据源Data source 缓存的数据Cached data 计划的刷新Scheduled refresh 实时/DirectQueryLive/DirectQuery
SQL Server 数据库SQL Server Database Yes Yes Yes
SQL Server Analysis ServicesSQL Server Analysis Services Yes Yes Yes
Azure SQL 数据库Azure SQL Database Yes Yes Yes
Azure SQL 数据仓库Azure SQL Data Warehouse Yes Yes Yes
ExcelExcel Yes Yes No
Access 数据库Access Database Yes Yes No
Active DirectoryActive Directory Yes Yes No
Amazon RedshiftAmazon Redshift Yes No No
Azure Blob 存储Azure Blob Storage Yes Yes No
Azure Data Lake StoreAzure Data Lake Store Yes No No
Azure HDInsight (HDFS)Azure HDInsight (HDFS) Yes Yes No
Azure HDInsight (Spark)Azure HDInsight (Spark) Yes Yes No
Azure 表存储Azure Table Storage Yes Yes No
Dynamics 365(联机)Dynamics 365 (online) Yes No No
FacebookFacebook Yes No No
文件夹Folder Yes Yes No
Google AnalyticsGoogle Analytics Yes No No
Hadoop 文件 (HDFS)Hadoop File (HDFS) Yes No No
IBM DB2 数据库IBM DB2 Database Yes Yes No
ImpalaImpala Yes No No
JSONJSON Yes Yes No
Microsoft ExchangeMicrosoft Exchange Yes No No
Microsoft Exchange OnlineMicrosoft Exchange Online Yes No No
MySQL 数据库MySQL Database Yes Yes No
OData 数据源OData Feed Yes Yes No
ODBCODBC Yes Yes No
OLE DBOLE DB Yes Yes No
Oracle 数据库Oracle Database Yes Yes Yes
PostgreSQL 数据库PostgreSQL Database Yes Yes No
Power BI 服务Power BI service No No No
R 脚本R Script Yes No No
Salesforce 对象Salesforce Objects Yes No No
Salesforce 报表Salesforce Reports Yes No No
SAP Business Warehouse 服务器SAP Business Warehouse server Yes Yes Yes
SAP HANA 数据库SAP HANA Database Yes Yes Yes
SharePoint 文件夹(本地)SharePoint Folder (on-premises) Yes Yes No
SharePoint 列表(本地)SharePoint List (on-premises) Yes Yes No
SharePoint Online 列表SharePoint Online List Yes No No
SnowflakeSnowflake Yes No No
Sybase 数据库Sybase Database Yes Yes No
Teradata 数据库Teradata Database Yes Yes Yes
文本/CSVText/CSV Yes Yes No
WebWeb Yes Yes No
XMLXML Yes Yes No
appFigures (Beta)appFigures (Beta) Yes No No
Azure Analysis Services 数据库 (Beta)Azure Analysis Services database (Beta) Yes No No
Azure Cosmos DB (Beta)Azure Cosmos DB (Beta) Yes No No
Azure HDInsight Spark (Beta)Azure HDInsight Spark (Beta) Yes No No
Common Data Service (Beta)Common Data Service (Beta) Yes No No
comScore Digital Analytix (Beta)comScore Digital Analytix (Beta) Yes No No
Dynamics 365 for Customer Insights (Beta)Dynamics 365 for Customer Insights (Beta) Yes No No
Dynamics 365 for Financials (Beta)Dynamics 365 for Financials (Beta) Yes No No
GitHub (Beta)GitHub (Beta) Yes No No
Google BigQuery (Beta)Google BigQuery (Beta) Yes No No
IBM Informix 数据库 (Beta)IBM Informix database (Beta) Yes No No
IBM Netezza (Beta)IBM Netezza (Beta) Yes No No
Kusto (Beta)Kusto (Beta) Yes No No
MailChimp (Beta)MailChimp (Beta) Yes No No
Microsoft Azure 使用情况见解 (Beta)Microsoft Azure Consumption Insights (Beta) Yes No No
Mixpanel (Beta)Mixpanel (Beta) Yes No No
Planview Enterprise (Beta)Planview Enterprise (Beta) Yes No No
Projectplace (Beta)Projectplace (Beta) Yes No No
QuickBooks Online (Beta)QuickBooks Online (Beta) Yes No No
SmartsheetSmartsheet Yes No No
Spark (Beta)Spark (Beta) Yes No No
SparkPost (Beta)SparkPost (Beta) Yes No No
SQL Sentry (Beta)SQL Sentry (Beta) Yes No No
Stripe (Beta)Stripe (Beta) Yes No No
SweetIQ (Beta)SweetIQ (Beta) Yes No No
Troux (Beta)Troux (Beta) Yes No No
Twilio (Beta)Twilio (Beta) Yes No No
tyGraph (Beta)tyGraph (Beta) Yes No No
Vertica (Beta)Vertica (Beta) Yes No No
Visual Studio Team Services (Beta)Visual Studio Team Services (Beta) Yes No No
Webtrends (Beta)Webtrends (Beta) Yes No No
Zendesk (Beta)Zendesk (Beta) Yes No No

重要

在数据源配置的行级别安全性应适用于某些 DirectQuery(SQL Server、Azure SQL 数据库、Oracle 和 Teradata),以及假设在你的环境中正确配置了 Kerberos 的实时连接。Row-level security configured at the data source should work for certain DirectQuery (SQL Server, Azure SQL Database, Oracle and Teradata) and live connections assuming Kerberos is configured properly in your environment.

后续步骤Next steps

现在你已选取了数据源,接下来使用该数据源中的数据创建报表Now that your data source is picked out, create a report using data from that data source.

更多问题?More questions? 尝试咨询 Power BI 社区Try asking the Power BI Community