{"id":27289,"date":"2020-12-18T11:35:25","date_gmt":"2020-12-18T11:35:25","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=27289"},"modified":"2020-12-18T11:36:14","modified_gmt":"2020-12-18T11:36:14","slug":"power-bi-data-sources","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/","title":{"rendered":"Power BI Data Sources"},"content":{"rendered":"\n<p>We shall present the table that shows the Power BI data source that support for datasets, including information about DirectQuery and the on-premises data gateway.\u00a0Learn about Power BI Data Source.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Data source<\/th><th>Connect from Desktop<\/th><th>Connect and refresh from service<\/th><th>DirectQuery \/ Live connection<\/th><th>Gateway (supported)<\/th><th>Gateway (required)<\/th><th>Power BI Dataflows<\/th><th><\/th><\/tr><\/thead><tbody><tr><td>Access database<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes&nbsp;<sup>1<\/sup><\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>ActiveDirectory<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Adobe Analytics<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Amazon Redshift<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>appFigures<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>AtScale cubes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Azure Analysis Services<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Azure Blob Storage<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Azure Cosmos DB<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Azure Cost Management<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Azure Data Explorer (kusto)<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Azure Data Lake Storage Gen1<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Azure Data Lake Storage Gen2<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Azure Databricks<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Azure DevOps<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Azure DevOps Server<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Azure HDInsight (HDFS)<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Azure HDInsight Spark<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Azure SQL Database<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Azure SQL Data Warehouse<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Azure Table Storage<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>BI Connector<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>BI360 &#8211; Budgeting &amp; Financial Reporting<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Microsoft Dataverse<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Data.World &#8211; Get Dataset<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Denodo<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Dremio<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Dynamics 365 (online)<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Dynamics 365 Business Central<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Dynamics 365 Business Central (on-premises)<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Dynamics 365 Customer Insights<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Dynamics NAV<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Emigo Data Source<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Entersoft Business Suite<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Essbase<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Exasol<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Excel<\/td><td>Yes&nbsp;<sup>3<\/sup><\/td><td>Yes&nbsp;<sup>3<\/sup><\/td><td>No<\/td><td>Yes&nbsp;<sup>3<\/sup><\/td><td>No&nbsp;<sup>4<\/sup><\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Facebook<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>File<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Folder<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>GitHub<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Google Analytics<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Google BigQuery<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Hadoop File (HDFS)<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Hive LLAP<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>HDInsight Interactive Query<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>IBM DB2<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>IBM Informix Database<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>IBM Netezza<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Impala<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Indexima<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Industrial App Store<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Information Grid<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Intersystems IRIS<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Intune Data Warehouse<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Jethro ODBC<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>JSON<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes**<\/td><td>No&nbsp;<sup>4<\/sup><\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Kyligence Enterprise<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>MailChimp<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Marketo<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>MarkLogic ODBC<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Microsoft Azure Consumption Insights<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Microsoft Exchange<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Microsoft Exchange Online<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Microsoft Graph Security<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Mixpanel<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>MySQL<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>OData<\/td><td>Yes<\/td><td>Yes&nbsp;<sup>7<\/sup><\/td><td>No<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>ODBC<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>OleDb<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Oracle<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Paxata&nbsp;<sup>8<\/sup><\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>PDF<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No&nbsp;<sup>4<\/sup><\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Planview Enterprise One &#8211; CTM<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Planview Enterprise One &#8211; PRM<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Planview Projectplace<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>PostgreSQL<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Power BI dataflows<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Power BI datasets<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Power platform dataflows<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Python script<\/td><td>Yes<\/td><td>Yes&nbsp;<sup>5<\/sup><\/td><td>No<\/td><td>Yes&nbsp;<sup>5<\/sup><\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>QubolePresto<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Quick Base<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>QuickBooks Online<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>R script<\/td><td>Yes<\/td><td>Yes&nbsp;<sup>5<\/sup><\/td><td>No<\/td><td>Yes&nbsp;<sup>5<\/sup><\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Roamler<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Salesforce Objects<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Salesforce Reports<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>SAP Business Warehouse Message Server<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>SAP Business Warehouse Server<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>SAP HANA<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>SharePoint Folder<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No&nbsp;<sup>4<\/sup><\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>SharePoint List<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No&nbsp;<sup>4<\/sup><\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>SharePoint Online List<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Smartsheet<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Snowflake<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Spark<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>SparkPost<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>SQL Server<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>SQL Server Analysis Services<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Stripe<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>SurveyMonkey<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>SweetIQ<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Sybase<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>TeamDesk<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Tenforce<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Teradata<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Text\/CSV<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No&nbsp;<sup>4<\/sup><\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Twilio<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>tyGraph<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Vertica<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Web<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>Yes&nbsp;<sup>6<\/sup><\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Webtrends<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>Workforce Dimensions<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td>XML<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>Yes<\/td><td>No&nbsp;<sup>4<\/sup><\/td><td>Yes<\/td><td><\/td><\/tr><tr><td>Zendesk<\/td><td>Yes<\/td><td>Yes<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td>No<\/td><td><\/td><\/tr><tr><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>For more details visit &#8211; <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/power-bi-data-sources\" target=\"_blank\" rel=\"noreferrer noopener\">Power BI Data Source<\/a><\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.testpreptraining.ai\/microsoft-power-platform-fundamentals-pl-900-free-practice-test\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/testpreptraining.ai-4-750x117.png\" alt=\"Microsoft Exam PL-900 Free Practice Test\"\/><\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>We shall present the table that shows the Power BI data source that support for datasets, including information about DirectQuery and the on-premises data gateway.\u00a0Learn about Power BI Data Source. Data source Connect from Desktop Connect and refresh from service DirectQuery \/ Live connection Gateway (supported) Gateway (required) Power BI Dataflows Access database Yes Yes&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-27289","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power BI Data Sources - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Boost your learning and get ready to qualify Microsoft Power Platform PL-900 Exam with latest practice test. Learn Power BI Data Source Now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI Data Sources - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Boost your learning and get ready to qualify Microsoft Power Platform PL-900 Exam with latest practice test. Learn Power BI Data Source Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-18T11:36:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/testpreptraining.ai-4-750x117.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/\",\"name\":\"Power BI Data Sources - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-12-18T11:35:25+00:00\",\"dateModified\":\"2020-12-18T11:36:14+00:00\",\"description\":\"Boost your learning and get ready to qualify Microsoft Power Platform PL-900 Exam with latest practice test. Learn Power BI Data Source Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI Data Sources\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI Data Sources - Testprep Training Tutorials","description":"Boost your learning and get ready to qualify Microsoft Power Platform PL-900 Exam with latest practice test. Learn Power BI Data Source Now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/","og_locale":"en_US","og_type":"article","og_title":"Power BI Data Sources - Testprep Training Tutorials","og_description":"Boost your learning and get ready to qualify Microsoft Power Platform PL-900 Exam with latest practice test. Learn Power BI Data Source Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2020-12-18T11:36:14+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/testpreptraining.ai-4-750x117.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/","name":"Power BI Data Sources - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-12-18T11:35:25+00:00","dateModified":"2020-12-18T11:36:14+00:00","description":"Boost your learning and get ready to qualify Microsoft Power Platform PL-900 Exam with latest practice test. Learn Power BI Data Source Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/power-bi-data-sources\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Power BI Data Sources"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/27289","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=27289"}],"version-history":[{"count":2,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/27289\/revisions"}],"predecessor-version":[{"id":27291,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/27289\/revisions\/27291"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=27289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=27289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=27289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}