Zdroje dat Power BIPower BI data sources

Následující tabulka obsahuje zdroje dat, které Power BI podporuje pro datové sady, včetně informací o DirectQuery a místní bráně dat.The following table shows the data sources that Power BI supports for datasets, including information about DirectQuery and the on-premises data gateway. Informace o tocích dat najdete v článku Připojení ke zdrojům dat pro toky dat Power BI.For information about dataflows, see Connect to data sources for Power BI dataflows.

Zdroj datData source Připojení z počítačeConnect from Desktop Připojení a aktualizace ze službyConnect and refresh from service DirectQuery / živé připojeníDirectQuery / Live connection Brána (podporováno)Gateway (supported) Brána (vyžadováno)Gateway (required) Toky dat Power BIPower BI Dataflows
Databáze aplikace AccessAccess database AnoYes YesYes NoNo Ano 1Yes 1 AnoYes AnoYes
ActiveDirectoryActiveDirectory AnoYes YesYes NoNo YesYes AnoYes AnoYes
Adobe AnalyticsAdobe Analytics AnoYes YesYes NoNo NoNo NoNo NoNo
Amazon RedshiftAmazon Redshift AnoYes YesYes AnoYes AnoYes NoNo YesYes
appFiguresappFigures AnoYes AnoYes NoNo NoNo NoNo NoNo
Datové krychle AtScaleAtScale cubes AnoYes AnoYes AnoYes YesYes NoNo NoNo
Azure Analysis ServicesAzure Analysis Services AnoYes YesYes YesYes NoNo NoNo NoNo
Azure Blob StorageAzure Blob Storage YesYes YesYes NoNo YesYes NoNo AnoYes
Azure Cosmos DBAzure Cosmos DB AnoYes YesYes NoNo NoNo NoNo NoNo
Azure Cost ManagementAzure Cost Management AnoYes YesYes NoNo NoNo NoNo NoNo
Azure Data Explorer (kusto)Azure Data Explorer (kusto) AnoYes AnoYes AnoYes YesYes NoNo YesYes
Azure Data Lake Storage Gen1Azure Data Lake Storage Gen1 AnoYes AnoYes NoNo NoNo NoNo NoNo
Azure Data Lake Storage Gen2Azure Data Lake Storage Gen2 AnoYes YesYes NoNo AnoYes NoNo AnoYes
Azure DevOpsAzure DevOps AnoYes YesYes NoNo NoNo NoNo NoNo
Azure DevOps ServerAzure DevOps Server AnoYes YesYes NoNo YesYes AnoYes NeNo
Azure HDInsight (HDFS)Azure HDInsight (HDFS) AnoYes YesYes NoNo NoNo NoNo NoNo
Azure HDInsight SparkAzure HDInsight Spark AnoYes YesYes AnoYes NoNo NoNo YesYes
Azure SQL DatabaseAzure SQL Database AnoYes AnoYes AnoYes AnoYes NoNo YesYes
Azure SQL Data WarehouseAzure SQL Data Warehouse AnoYes YesYes YesYes YesYes NoNo AnoYes
Azure Table StorageAzure Table Storage YesYes YesYes NoNo YesYes NoNo AnoYes
Konektor BIBI Connector AnoYes YesYes YesYes AnoYes AnoYes NoNo
BI360 – Budgeting & Financial ReportingBI360 - Budgeting & Financial Reporting AnoYes YesYes NoNo NoNo NoNo NoNo
Common Data ServiceCommon Data Service AnoYes AnoYes NoNo NoNo NoNo YesYes
Data.World – získat datovou saduData.World - Get Dataset AnoYes AnoYes NoNo NoNo NoNo NoNo
DenodoDenodo AnoYes YesYes YesYes YesYes YesYes NoNo
DremioDremio AnoYes YesYes YesYes YesYes AnoYes NeNo
Dynamics 365 (online)Dynamics 365 (online) AnoYes YesYes NoNo NoNo NoNo NoNo
Dynamics 365 Business CentralDynamics 365 Business Central AnoYes YesYes NoNo NoNo NoNo NoNo
Dynamics 365 Business Central (v místním prostředí)Dynamics 365 Business Central (on-premises) AnoYes AnoYes NoNo NoNo NoNo NoNo
Dynamics 365 Customer InsightsDynamics 365 Customer Insights AnoYes AnoYes NoNo NoNo NoNo NoNo
Dynamics NAVDynamics NAV AnoYes YesYes NoNo NoNo NoNo NoNo
Emigo Data SourceEmigo Data Source AnoYes YesYes NoNo NoNo NoNo NoNo
Entersoft Business SuiteEntersoft Business Suite YesYes AnoYes NoNo NoNo NoNo NoNo
EssbaseEssbase AnoYes YesYes AnoYes AnoYes YesYes NoNo
ExasolExasol AnoYes AnoYes AnoYes YesYes YesYes NoNo
ExcelExcel Ano 3Yes 3 Ano 3Yes 3 NoNo Ano 3Yes 3 Ne 4No 4 YesYes
FacebookFacebook AnoYes YesYes NoNo NoNo NoNo NoNo
SouborFile AnoYes YesYes NoNo YesYes AnoYes AnoYes
SložkaFolder AnoYes YesYes NoNo AnoYes AnoYes AnoYes
GitHubGitHub AnoYes YesYes NoNo NoNo NoNo NoNo
Google AnalyticsGoogle Analytics AnoYes AnoYes NoNo NoNo NoNo NoNo
Google BigQueryGoogle BigQuery AnoYes AnoYes AnoYes YesYes NoNo YesYes
Soubor Hadoop (HDFS)Hadoop File (HDFS) AnoYes NoNo NoNo NoNo NoNo NoNo
Hive LLAPHive LLAP AnoYes YesYes YesYes YesYes NoNo NoNo
HDInsight Interactive QueryHDInsight Interactive Query AnoYes AnoYes YesYes NoNo NoNo NoNo
IBM DB2IBM DB2 AnoYes YesYes YesYes AnoYes NoNo YesYes
Databáze IBM InformixIBM Informix Database AnoYes YesYes NoNo YesYes NoNo NeNo
IBM NetezzaIBM Netezza AnoYes AnoYes AnoYes AnoYes AnoYes NeNo
ImpalaImpala AnoYes YesYes YesYes YesYes YesYes AnoYes
IndeximaIndexima AnoYes YesYes YesYes YesYes YesYes NoNo
Industrial App StoreIndustrial App Store AnoYes AnoYes NoNo NoNo NoNo NoNo
Information GridInformation Grid AnoYes YesYes NoNo NoNo NoNo NoNo
Intersystems IRISIntersystems IRIS AnoYes AnoYes YesYes YesYes YesYes NoNo
Intune Data WarehouseIntune Data Warehouse AnoYes AnoYes NoNo NoNo NoNo NeNo
Jethro ODBCJethro ODBC AnoYes YesYes YesYes YesYes YesYes NeNo
JSONJSON AnoYes YesYes NoNo Ano**Yes** Ne 4No 4 AnoYes
Kyligence EnterpriseKyligence Enterprise YesYes YesYes YesYes YesYes YesYes NoNo
MailChimpMailChimp AnoYes YesYes NoNo NoNo NoNo NoNo
MarketoMarketo AnoYes AnoYes NoNo NoNo NoNo NoNo
MarkLogic ODBCMarkLogic ODBC AnoYes AnoYes YesYes YesYes YesYes NoNo
Microsoft Azure Consumption InsightsMicrosoft Azure Consumption Insights AnoYes YesYes NoNo NoNo NoNo NoNo
Microsoft ExchangeMicrosoft Exchange AnoYes YesYes NoNo YesYes NoNo NoNo
Microsoft Exchange OnlineMicrosoft Exchange Online AnoYes YesYes NoNo NoNo NoNo AnoYes
Microsoft Graph SecurityMicrosoft Graph Security AnoYes YesYes NoNo YesYes NoNo NoNo
MixpanelMixpanel AnoYes AnoYes NoNo NoNo NoNo NoNo
MySQLMySQL AnoYes YesYes NoNo YesYes YesYes YesYes
ODataOData AnoYes Ano 7Yes 7 NoNo YesYes NoNo AnoYes
ODBCODBC AnoYes YesYes NoNo YesYes AnoYes AnoYes
OleDbOleDb AnoYes AnoYes NoNo AnoYes AnoYes NoNo
OracleOracle AnoYes YesYes YesYes AnoYes YesYes AnoYes
Paxata 8Paxata 8 AnoYes AnoYes NoNo AnoYes NoNo NoNo
PDFPDF AnoYes AnoYes NoNo AnoYes Ne 4No 4 YesYes
Planview Enterprise One – CTMPlanview Enterprise One - CTM AnoYes YesYes NoNo NoNo NoNo NoNo
Planview Enterprise One – PRMPlanview Enterprise One - PRM AnoYes YesYes NoNo NoNo NoNo NoNo
Planview ProjectplacePlanview Projectplace AnoYes AnoYes NoNo NoNo NoNo NoNo
PostgreSQLPostgreSQL AnoYes YesYes YesYes YesYes NoNo AnoYes
Toky dat Power BIPower BI dataflows AnoYes AnoYes NoNo NoNo NoNo AnoYes
Datové sady Power BIPower BI datasets AnoYes AnoYes YesYes NoNo NoNo NoNo
Toky dat Power PlatformPower platform dataflows AnoYes YesYes NoNo NoNo NoNo YesYes
Skript jazyka PythonPython script AnoYes Ano 5Yes 5 NoNo Ano 5Yes 5 AnoYes NoNo
QubolePrestoQubolePresto AnoYes YesYes YesYes AnoYes AnoYes NoNo
Quick BaseQuick Base AnoYes YesYes NoNo YesYes YesYes NoNo
QuickBooks OnlineQuickBooks Online AnoYes YesYes NoNo NoNo NoNo NoNo
Skript jazyka RR script YesYes Ano 5Yes 5 NoNo Ano 5Yes 5 NoNo NoNo
RoamlerRoamler AnoYes YesYes NoNo YesYes NoNo NoNo
Objekty SalesforceSalesforce Objects AnoYes YesYes NoNo NoNo NoNo AnoYes
Sestavy SalesforceSalesforce Reports AnoYes YesYes NoNo NoNo NoNo AnoYes
Server zpráv SAP Business WarehouseSAP Business Warehouse Message Server AnoYes YesYes AnoYes AnoYes YesYes YesYes
Server SAP Business WarehouseSAP Business Warehouse Server AnoYes AnoYes AnoYes YesYes YesYes AnoYes
SAP HANASAP HANA YesYes AnoYes YesYes AnoYes YesYes YesYes
Sharepointová složkaSharePoint Folder AnoYes YesYes NoNo AnoYes Ne 4No 4 AnoYes
Sharepointový seznamSharePoint List AnoYes YesYes NoNo YesYes Ne 4No 4 AnoYes
Seznam služby SharePoint OnlineSharePoint Online List AnoYes YesYes NoNo YesYes NoNo AnoYes
SmartsheetSmartsheet AnoYes YesYes NoNo NoNo NoNo AnoYes
SnowflakeSnowflake AnoYes AnoYes AnoYes YesYes NoNo YesYes
SparkSpark AnoYes AnoYes YesYes YesYes NoNo YesYes
SparkPostSparkPost AnoYes YesYes NoNo NoNo NoNo NoNo
SQL ServerSQL Server YesYes YesYes YesYes YesYes YesYes YesYes
SQL Server Analysis ServicesSQL Server Analysis Services AnoYes YesYes YesYes YesYes YesYes NoNo
StripeStripe AnoYes YesYes NoNo NoNo NoNo NoNo
SurveyMonkeySurveyMonkey AnoYes YesYes NoNo YesYes NoNo NoNo
SweetIQSweetIQ AnoYes YesYes NoNo NoNo NoNo NoNo
SybaseSybase AnoYes YesYes NoNo YesYes YesYes AnoYes
TeamDeskTeamDesk AnoYes YesYes NoNo YesYes NoNo NoNo
TenforceTenforce YesYes YesYes NoNo NoNo NoNo NoNo
TeradataTeradata YesYes YesYes YesYes AnoYes YesYes YesYes
Text/CSVText/CSV AnoYes YesYes NoNo AnoYes Ne 4No 4 YesYes
TwilioTwilio AnoYes YesYes NoNo NoNo NoNo NoNo
tyGraphtyGraph AnoYes YesYes NoNo NoNo NoNo NoNo
VerticaVertica YesYes YesYes YesYes AnoYes YesYes YesYes
WebWeb AnoYes YesYes NoNo AnoYes Ano 6Yes 6 YesYes
WebtrendsWebtrends AnoYes YesYes NoNo NoNo NoNo NoNo
Workforce DimensionsWorkforce Dimensions YesYes YesYes NoNo AnoYes NoNo NoNo
XMLXML AnoYes YesYes NoNo AnoYes Ne 4No 4 YesYes
ZendeskZendesk AnoYes YesYes NoNo NoNo NoNo NoNo

1 Podporováno se zprostředkovatelem ACE OLEDB, který je nainstalovaný na stejném počítači jako brána.1 Supported with the ACE OLEDB provider, installed on the same machine as the gateway.

3 Soubory aplikace Excel 1997–2003 (.xls) vyžadují zprostředkovatele ACE OLEDB.3 Excel 1997-2003 files (.xls) require the ACE OLEDB provider.

4 Vyžadováno pro místní verzi technologie.4 Required for the on-premises version of the technology.

5 Podporováno pouze s osobní bránou.5 Supported only with the personal gateway.

6 Povinné pro .html, .xls a databáze Access6 Required for .html, .xls, and Access Databases

7 Služba Power BI nepodporuje obecné OAuth2.7 Power BI service doesn't support generic OAuth2.

8 Zdroj dat Paxata je podporovaný ve verzi Power BI Desktopu, která je optimalizovaná pro Server sestav Power BI.8 Paxata is supported in the version of Power BI Desktop optimized for Power BI Report Server. Není podporovaný v sestavách Power BI publikovaných na Server sestav Power BI.It isn't supported in Power BI reports published to Power BI Report Server. Seznam podporovaných zdrojů dat najdete v článku Zdroje dat sestav Power BI v Serveru sestav Power BI.See Power BI report data sources in Power BI Report Server for the list of supported data sources.

Důležité informace a omezeníConsiderations and limitations

  • Řada datových konektorů Power BI Desktopu vyžaduje k ověřování Internet Explorer 10 (nebo novější).Many data connectors for Power BI Desktop require Internet Explorer 10 (or newer) for authentication.
  • Některé zdroje dat, které jsou k dispozici v Power BI Desktopu, sice jsou optimalizované pro Server sestav Power BI, ale nepodporují publikování na Serveru sestav Power BI.Some data sources are available in Power BI Desktop optimized for Power BI Report Server, but aren't supported when published to Power BI Report Server. Seznam podporovaných zdrojů dat najdete v článku Zdroje dat sestav Power BI v Serveru sestav Power BI.See Power BI report data sources in Power BI Report Server for the list of supported data sources.

Jednotné přihlašování (SSO) u zdrojů DirectQuerySingle sign-on (SSO) for DirectQuery sources

Když je možnost jednotného přihlašování povolená a uživatelé přistupují k sestavám vytvořeným nad zdrojem dat, odesílá Power BI jejich ověřené přihlašovací údaje službě Azure AD v dotazech na podkladový zdroj dat.When the SSO option is enabled and your users access reports built atop the data source, Power BI sends their authenticated Azure AD credentials in the queries to the underlying data source. To umožňuje službě Power BI respektovat nastavení zabezpečení, která jsou nakonfigurovaná na úrovni zdroje dat.This enables Power BI to respect the security settings that are configured at the data source level. Možnost jednotného přihlašování se projeví u všech datových sad, které tento zdroj dat používají.The SSO option takes effect across all datasets that use this data source. Neovlivňuje metodu ověřování použitou pro scénáře importu.It does not affect the authentication method used for import scenarios. Následující zdroje dat podporují jednotné přihlašování pro připojení přes DirectQuery:The following data sources support SSO for connections through DirectQuery:

  • Azure SQL DatabaseAzure SQL Database
  • Azure SQL Data WarehouseAzure SQL Data Warehouse
  • ImpalaImpala
  • SAP HANASAP HANA
  • SAP BWSAP BW
  • Server zpráv SAP BWSAP BW Message Server
  • SnowflakeSnowflake
  • SparkSpark
  • SQL ServerSQL Server
  • TeradataTeradata

Další krokyNext steps

Připojení k datům v Power BI DesktopuConnect to data in Power BI Desktop
Použití DirectQuery v Power BIUsing DirectQuery in Power BI
Živá data SQL Server Analysis Services v Power BISQL Server Analysis Services live data in Power BI
Co je místní brána dat?What is an on-premises data gateway?
Zdroje dat sestav Power BI v Serveru sestav Power BIPower BI report data sources in Power BI Report Server