Power BI 中 DirectQuery 支持的数据源Data sources supported by DirectQuery in Power BI

Power BI Desktop 和 Power BI 服务有多个可以连接并访问数据的数据源。Power BI Desktop and the Power BI service have many data sources to which you can connect and get access to data. 本文介绍了支持称为 DirectQuery 的连接方法的 Power BI 数据源。This article describes which data sources for Power BI support the connection method known as DirectQuery. 有关 DirectQuery 的详细信息,请参阅 Power BI 中的 DirectQueryFor more information about DirectQuery, see DirectQuery in Power BI.

在 Power BI 中,以下数据源支持 DirectQuery:The following data sources support DirectQuery in Power BI:

  • Amazon RedshiftAmazon Redshift
  • Azure HDInsight Spark (Beta)Azure HDInsight Spark (Beta)
  • Azure SQL 数据库Azure SQL Database
  • Azure SQL 数据仓库Azure SQL Data Warehouse
  • Google BigQuery (Beta)Google BigQuery (Beta)
  • IBM Netezza (Beta)IBM Netezza (Beta)
  • Impala(版本 2.x)Impala (version 2.x)
  • Oracle 数据库(版本 12 及更高版本)Oracle Database (version 12 and above)
  • SAP Business Warehouse (Beta)SAP Business Warehouse (Beta)
  • SAP HANASAP HANA
  • SnowflakeSnowflake
  • Spark (Beta)(版本 0.9 及更高版本)Spark (Beta) (version 0.9 and above)
  • SQL ServerSQL Server
  • Teradata 数据库Teradata Database
  • Vertica (Beta)Vertica (Beta)

名称后带有 (Beta) 或(预览)的数据源会发生更改,不支持在生产环境中使用。Data sources that are have (Beta) or (Preview) after their name are subject to change, and are not supported for production use. 在将报表发布到 Power BI 服务后这些数据源可能还不受支持,这意味着打开已发布的报表或浏览数据集会导致错误。They might also not be supported after publishing a report to the Power BI service, which means that that opening a published report or exploring the dataset can result in an error.

(Beta) 与(预览)数据源之间的唯一区别是(预览)数据源必须先要作为预览功能启用,然后才可供使用。The only difference between (Beta) and (Preview) data sources is that (Preview) sources must be enabled as a Preview feature before they become available for use. 若要启用(预览)数据连接器,请在 Power BI Desktop 中转到“文件 > 选项和设置”,然后访问“设置 > 选项 > 预览功能”。To enable a (Preview) data connector, in Power BI Desktop go to File > Options and Settings, and then Settings > Options > Preview features.

本地网关要求On-premises gateway requirements

下表指定在将报表发布到 Power BI 服务后本地数据网关是否需要连接到指定的数据源。The following table specifies whether an on-premises data gateway is required to connect to the specified data source, after publishing a report to the Power BI service.

Source 需要网关?Gateway required?
SQL ServerSQL Server Yes
Azure SQL 数据库Azure SQL Database No
Azure SQL 数据仓库Azure SQL Data Warehouse No
SAP HANASAP HANA Yes
Oracle 数据库Oracle Database Yes
Teradata 数据库Teradata Database Yes
Amazon RedshiftAmazon Redshift No
Impala(版本 2.x)Impala (version 2.x) Yes
Snowflake(预览)Snowflake (Preview) 在 Power BI 服务中尚不受支持Not yet supported in the Power BI service
Spark (Beta),版本 0.9 及更高版本Spark (beta), version 0.9 and later 在 Power BI 服务中尚不受支持Not yet supported in the Power BI service
Azure HDInsight Spark (Beta)Azure HDInsight Spark (Beta) 在 Power BI 服务中尚不受支持Not yet supported in the Power BI service
IBM Netezza (Beta)IBM Netezza (Beta) 在 Power BI 服务中尚不受支持Not yet supported in the Power BI service
SAP Buisness Warehouse (Beta)SAP Buisness Warehouse (Beta) 在 Power BI 服务中尚不受支持Not yet supported in the Power BI service

后续步骤Next steps

有关 DirectQuery 的详细信息,请查看以下资源:For more information about DirectQuery, check out the following resources: