{"id":19621,"date":"2018-07-24T04:00:02","date_gmt":"2018-07-24T04:00:02","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=19621"},"modified":"2018-09-11T23:10:33","modified_gmt":"2018-09-11T17:40:33","slug":"power-bi-data-sources","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/","title":{"rendered":"Power BI Data Sources (Supported) &#8211; Connecting Data Source"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1873,&quot;href&quot;:&quot;https:\\\/\\\/docs.microsoft.com\\\/en-us\\\/power-bi\\\/desktop-directquery-data-sources&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20190831024704\\\/https:\\\/\\\/docs.microsoft.com\\\/en-us\\\/power-bi\\\/desktop-directquery-data-sources&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 05:55:11&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-15 02:00:18&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-24 20:44:26&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-06 10:20:43&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-13 01:55:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-19 18:57:28&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-26 16:40:00&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-26 19:56:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-15 11:48:10&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-04-15 11:48:10&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<h2 class=\"western\">1. Objective<\/h2>\n<p>In this<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-tutorial\/\"> Power BI tutorial<\/a><\/strong>, we will learn about Power BI Data Sources and the format which supported by Power BI. In addition, we will discuss Data Sources in Power Metal Desktop are: All Class, File class, Database Class, Online Services Class, Azure Class, and\u00a0Other Class. At last, we will see\u00a0How can we Connect a Data Source in Power BI.<br \/>\nSo, let&#8217;s start Power BI Data Source.<\/p>\n<div id=\"attachment_19647\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-BI-Supported-Data-Sources-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-19647\" class=\"wp-image-19647 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-BI-Supported-Data-Sources-01.jpg\" alt=\"Power Bi Data Sources\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-BI-Supported-Data-Sources-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-BI-Supported-Data-Sources-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-BI-Supported-Data-Sources-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-BI-Supported-Data-Sources-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-BI-Supported-Data-Sources-01-1024x536.jpg 1024w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-19647\" class=\"wp-caption-text\">Power BI Data Sources (Supported) &#8211; Connecting Data Source<\/p><\/div>\n<h2>2. Power BI Data Sources<\/h2>\n<p>Data is at the center of Power atomic number 83. Whenever you are exploring information, making charts and dashboards, asking queries with Q&amp;A. All of these visualizations and answers you see square measure extremely obtaining their underlying information from a dataset. Wherever will that dataset come back from? Well, from a knowledge supply.<br \/>\nIn this Power BI Data Source Article, we&#8217;re getting to check the various kinds of information sources you&#8217;ll connect with from the ability atomic number 83 service. Keep in mind, there square measure several different kinds of information sources you&#8217;ll get information from, too. However, those may need 1st exploitation Power atomic number 83 Desktop or Excel&#8217;s advanced information question and modeling options. We&#8217;ll go in a lot of that later. For now, let&#8217;s look into the various kinds of information sources you&#8217;ll connect with right from your Power atomic number 83 service website.<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-dashboard\/\">Do you know How to\u00a0Create Power BI Dashboard with Example\u00a0<\/a><\/strong><\/p>\n<h2>3. Data Sources in Power Metal Desktop<\/h2>\n<p>With Power metal Desktop, you&#8217;ll hook up with information from many alternative sources. A full list of obtainable information sources is at an all-time low of this page.<br \/>\nTo connect to information, choose to Get information from the house ribbon. Choosing the down arrow, or the Get information text on the button, shows the foremost Common information sorts menu shown within the following image:<\/p>\n<div id=\"attachment_19649\" style=\"width: 601px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_01.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-19649\" class=\"wp-image-19649 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_01.png\" alt=\"Power Bi Data Sources\" width=\"591\" height=\"709\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_01.png 591w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_01-125x150.png 125w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_01-250x300.png 250w\" sizes=\"auto, (max-width: 591px) 100vw, 591px\" \/><\/a><p id=\"caption-attachment-19649\" class=\"wp-caption-text\">Power BI Data Sources in Power Metal Desktop<\/p><\/div>\n<p>Selecting More\u2026 from the foremost Common menu displays the Get information window. You&#8217;ll conjointly point out the Get information window (and bypass the foremost Common menu) by choosing the Get information icon button directly.<\/p>\n<div id=\"attachment_19650\" style=\"width: 1139px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_02.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-19650\" class=\"wp-image-19650 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_02.png\" alt=\"Power Bi Data Sources\" width=\"1129\" height=\"900\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_02.png 1129w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_02-150x120.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_02-300x239.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_02-768x612.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_02-1024x816.png 1024w\" sizes=\"auto, (max-width: 1129px) 100vw, 1129px\" \/><\/a><p id=\"caption-attachment-19650\" class=\"wp-caption-text\">Data Sources in Power Metal Desktop<\/p><\/div>\n<p><b>Note <em>&#8211;\u00a0<\/em><\/b><em>The Power metal team is frequently increasing the information sources obtainable to Power metal Desktop and also the Power metal service. As such, you will typically see early versions of work-in-progress information sources marked as Beta or Preview. Any information supply marked as Beta or Preview has restricted support and practicality, and may not be employed in production environments.<\/em><br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/\">Let&#8217;s explore Power BI Architecture \u2013 With Data Security<\/a><\/strong><\/p>\n<h2>4. Power BI Data Sources<\/h2>\n<p>Data sort are organized within the following categories:<\/p>\n<div id=\"attachment_19685\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-Bi-Data-Source-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-19685\" class=\"wp-image-19685 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-Bi-Data-Source-01.jpg\" alt=\"Power Bi Data Sources\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-Bi-Data-Source-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-Bi-Data-Source-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-Bi-Data-Source-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-Bi-Data-Source-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-Bi-Data-Source-01-1024x536.jpg 1024w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-19685\" class=\"wp-caption-text\">Power Bi Data Sources<\/p><\/div>\n<h3>a. All Class<\/h3>\n<p>The<em> All-class<\/em> includes all information affiliation sorts from all classes.<\/p>\n<h3>b. File Class<\/h3>\n<p>The <em>File class<\/em> provides the subsequent information connections:<\/p>\n<ul>\n<li>Excel<\/li>\n<li>Text\/CSV<\/li>\n<li>XML<\/li>\n<li>JSON<\/li>\n<li>Folder<\/li>\n<li>SharePoint Folder<\/li>\n<\/ul>\n<p>The following image shows the Get information window for File.<\/p>\n<div id=\"attachment_19651\" style=\"width: 627px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_03.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-19651\" class=\"wp-image-19651 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_03.png\" alt=\"Power Bi Data Sources\" width=\"617\" height=\"670\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_03.png 617w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_03-138x150.png 138w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_03-276x300.png 276w\" sizes=\"auto, (max-width: 617px) 100vw, 617px\" \/><\/a><p id=\"caption-attachment-19651\" class=\"wp-caption-text\">Power BI Data Sources &#8211;\u00a0File Class<\/p><\/div>\n<h3>c. Database Class<\/h3>\n<p>The<em> database class<\/em> provides the subsequent information connections:<\/p>\n<ul>\n<li>SQL Server database<\/li>\n<li>Access info<\/li>\n<li>SQL Server Analysis Services database<\/li>\n<li>Oracle info<\/li>\n<li>IBM DB2 info<\/li>\n<li>IBM Informix info (Beta)<\/li>\n<li>IBM Netezza<\/li>\n<li>MySQL info<\/li>\n<li>PostgreSQL info<\/li>\n<li>Sybase info<\/li>\n<li>Teradata info<\/li>\n<li>SAP HANA info<\/li>\n<li>SAP Business Warehouse Application Server<\/li>\n<li>SAP Business Warehouse Message Server (Beta)<\/li>\n<li>Amazon Redshift<\/li>\n<li><a href=\"https:\/\/data-flair.training\/blogs\/impala-tutorial\/\"><strong>Impala<\/strong><\/a><\/li>\n<li>Google BigQuery<\/li>\n<li>Snowflake<\/li>\n<li>Exasol<\/li>\n<\/ul>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/workspace-in-power-bi\/\">Do you know How to Create Workspace in Power BI\u00a0<\/a><\/strong><br \/>\nSome info connexions need that you simply modify them by choosing File &gt; choices and settings &gt; choices than choosing Preview options and enabling the connector. If you do not see a number of the connectors mentioned on top of and wish to use them, check your Preview options settings. Conjointly note that any information supply marked as Beta or Preview has restricted support and practicality, and may not be employed in production environments.<br \/>\nThe following image shows the Get information window for info.<\/p>\n<div id=\"attachment_19652\" style=\"width: 627px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_04.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-19652\" class=\"wp-image-19652 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_04.png\" alt=\"Power Bi Data Sources\" width=\"617\" height=\"670\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_04.png 617w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_04-138x150.png 138w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_04-276x300.png 276w\" sizes=\"auto, (max-width: 617px) 100vw, 617px\" \/><\/a><p id=\"caption-attachment-19652\" class=\"wp-caption-text\">Power BI Data Sources &#8211;\u00a0Database-Class<\/p><\/div>\n<h3>d. Power Metal Class<\/h3>\n<p>The <em>Power metal class<\/em> provides the subsequent information connections:<\/p>\n<ul>\n<li>Power metal datasets<\/li>\n<li>Power metal data pools (beta)<\/li>\n<\/ul>\n<p>The following image shows the Get information window for Power metal.<\/p>\n<div id=\"attachment_19653\" style=\"width: 627px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_05.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-19653\" class=\"wp-image-19653 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_05.png\" alt=\"Power Bi Data Sources\" width=\"617\" height=\"670\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_05.png 617w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_05-138x150.png 138w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_05-276x300.png 276w\" sizes=\"auto, (max-width: 617px) 100vw, 617px\" \/><\/a><p id=\"caption-attachment-19653\" class=\"wp-caption-text\">Power BI Data Sources &#8211;\u00a0Power Metal Class<\/p><\/div>\n<h3>e. Azure Class<\/h3>\n<p>The <em>Azure class<\/em> provides the subsequent information connections:<\/p>\n<ul>\n<li>Azure SQL info<\/li>\n<li>Azure SQL information Warehouse<\/li>\n<li>Azure Analysis Services info<\/li>\n<li>Azure Blob Storage<\/li>\n<li>Azure Table Storage<\/li>\n<li>Azure Cosmos sound unit (Beta)<\/li>\n<li>Azure information Lake Store<\/li>\n<li>Azure HDInsight (<a href=\"https:\/\/data-flair.training\/blogs\/apache-hadoop-hdfs-introduction-tutorial\/\"><strong>HDFS<\/strong><\/a>)<\/li>\n<li>Azure HDInsight <a href=\"https:\/\/data-flair.training\/blogs\/apache-spark-for-beginners\/\"><strong>Spark<\/strong><\/a> (Beta)<\/li>\n<li>HDInsight Interactive question (Beta)<\/li>\n<li>Azure KustoDB (beta)<\/li>\n<\/ul>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-data-modeling\/\">Read about Power BI Data Modeling \u2013 Creating Calculated Columns<\/a><\/strong><br \/>\nThe following image shows the Get information window for Azure.<\/p>\n<div id=\"attachment_19654\" style=\"width: 627px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_06.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-19654\" class=\"wp-image-19654 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_06.png\" alt=\"Power Bi Data Sources\" width=\"617\" height=\"670\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_06.png 617w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_06-138x150.png 138w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_06-276x300.png 276w\" sizes=\"auto, (max-width: 617px) 100vw, 617px\" \/><\/a><p id=\"caption-attachment-19654\" class=\"wp-caption-text\">Power BI Data Sources &#8211;\u00a0Azure Class<\/p><\/div>\n<h3>f. Online Service Class<\/h3>\n<p>The <em>Online Services class<\/em> provides the subsequent information connections:<\/p>\n<ul>\n<li>SharePoint online List<\/li>\n<li>Microsoft Exchange online<\/li>\n<li>Dynamics 365 (online)<\/li>\n<li>Dynamics NAV (Beta)<\/li>\n<li>Dynamics 365 Business Central<\/li>\n<li>Common information Service for Apps(Beta)<\/li>\n<li>Common information Service (Beta)<\/li>\n<li>Microsoft Azure Consumption Insights (Beta)<\/li>\n<li>Visual Studio Team Services (Beta)<\/li>\n<li>Salesforce Objects<\/li>\n<li>Salesforce Reports<\/li>\n<li>Google Analytics<\/li>\n<li>Adobe Analytics<\/li>\n<li>appFigures (Beta)<\/li>\n<li>comScore Digital Analytix (Beta)<\/li>\n<li>Dynamics 365 for client Insights (Beta)<\/li>\n<li>Data.World &#8211; Get Dataset (Beta)<\/li>\n<li>Facebook<\/li>\n<li>GitHub (Beta)<\/li>\n<li>MailChimp (Beta)<\/li>\n<li>Marketo (Beta)<\/li>\n<li>Mixpanel (Beta)<\/li>\n<li>Planview Enterprise One &#8211; PRM (Beta)<\/li>\n<li>Planview Projectplace (Beta)<\/li>\n<li>QuickBooks online (Beta)<\/li>\n<li>Smartsheet<\/li>\n<li>SparkPost (Beta)<\/li>\n<li>Stripe (Beta)<\/li>\n<li>SweetIQ (Beta)<\/li>\n<li>Planview Enterprise One &#8211; CMT (Beta)<\/li>\n<li>Twilio (Beta)<\/li>\n<li>tyGraph (Beta)<\/li>\n<li>Webtrends (Beta)<\/li>\n<li>Zendesk (Beta)<\/li>\n<li>TeamDesk (Beta)<\/li>\n<\/ul>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-view-dashboard\/\">Let&#8217;s Learn about Power BI View Dashboard &amp; Report on Mobile, Tab, PC<\/a><\/strong><br \/>\nThe following image shows the Get information window for on-line Services.<\/p>\n<div id=\"attachment_19655\" style=\"width: 627px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_07.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-19655\" class=\"wp-image-19655 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_07.png\" alt=\"Power Bi Data Sources\" width=\"617\" height=\"670\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_07.png 617w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_07-138x150.png 138w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_07-276x300.png 276w\" sizes=\"auto, (max-width: 617px) 100vw, 617px\" \/><\/a><p id=\"caption-attachment-19655\" class=\"wp-caption-text\">Power BI Data Sources &#8211;\u00a0Online Service Class<\/p><\/div>\n<h3>g. Other Class<\/h3>\n<p>The <em>Other class<\/em> provides the subsequent information connections:<\/p>\n<ul>\n<li>Vertica (Beta)<\/li>\n<li>Web<\/li>\n<li>SharePoint List<\/li>\n<li>OData Feed<\/li>\n<li>Active Directory<\/li>\n<li>Microsoft Exchange<\/li>\n<li>Hadoop File (<a href=\"https:\/\/data-flair.training\/blogs\/hadoop-hdfs-tutorial\/\"><strong>HDFS<\/strong><\/a>)<\/li>\n<li><strong><a href=\"https:\/\/data-flair.training\/blogs\/apache-spark-tutorial\/\">Spark<\/a><\/strong> (Beta)<\/li>\n<li><a href=\"https:\/\/data-flair.training\/blogs\/r-programming-tutorial\/\"><strong>R<\/strong> <\/a>Script<\/li>\n<li>ODBC<\/li>\n<li>OLE DB<\/li>\n<li>Blank question<\/li>\n<\/ul>\n<p>The following image shows the Get information window for an alternative.<\/p>\n<div id=\"attachment_19656\" style=\"width: 627px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_08.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-19656\" class=\"wp-image-19656 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_08.png\" alt=\"Power Bi Data Sources\" width=\"617\" height=\"670\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_08.png 617w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_08-138x150.png 138w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_08-276x300.png 276w\" sizes=\"auto, (max-width: 617px) 100vw, 617px\" \/><\/a><p id=\"caption-attachment-19656\" class=\"wp-caption-text\">Power BI Data Sources &#8211; Other Class<\/p><\/div>\n<p><b>Note &#8211;\u00a0<\/b>At now, it is not attainable to attach to custom information sources secured victimization Azure Active Directory.<\/p>\n<h2>5. How Can We Connect a Data Source in Power BI<\/h2>\n<p>To connect to a knowledge supply, choose the information supply from the Get information window and choose Connect. Within the following image, the internet is chosen from the opposite information affiliation class.<\/p>\n<div id=\"attachment_19657\" style=\"width: 627px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_08a.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-19657\" class=\"wp-image-19657 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_08a.png\" alt=\"Power Bi Data Sources\" width=\"617\" height=\"670\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_08a.png 617w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_08a-138x150.png 138w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/data-sources_08a-276x300.png 276w\" sizes=\"auto, (max-width: 617px) 100vw, 617px\" \/><\/a><p id=\"caption-attachment-19657\" class=\"wp-caption-text\">How can we Connect a Data Source in Power Bi<\/p><\/div>\n<p>An affiliation window is displayed, specific to the sort of information affiliation. If credentials are needed, you\u2019ll be prompted to produce them. The subsequent image shows a URL being entered to attach to an internet information supply.<\/p>\n<div id=\"attachment_19658\" style=\"width: 892px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/datasources_fromnavigatordialog.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-19658\" class=\"wp-image-19658 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/datasources_fromnavigatordialog.png\" alt=\"Power Bi Data Sources\" width=\"882\" height=\"702\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/datasources_fromnavigatordialog.png 882w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/datasources_fromnavigatordialog-150x119.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/datasources_fromnavigatordialog-300x239.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/datasources_fromnavigatordialog-768x611.png 768w\" sizes=\"auto, (max-width: 882px) 100vw, 882px\" \/><\/a><p id=\"caption-attachment-19658\" class=\"wp-caption-text\">Connecting a Data Source in Power Bi<\/p><\/div>\n<p>When the URL or resource affiliation data is entered, select OK. Power metal Desktop makes the affiliation to the information supply and presents the obtainable information sources within the Navigator.<\/p>\n<div id=\"attachment_19659\" style=\"width: 712px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/datasources_fromwebbox.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-19659\" class=\"wp-image-19659 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/datasources_fromwebbox.png\" alt=\"Power Bi Data Sources\" width=\"702\" height=\"252\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/datasources_fromwebbox.png 702w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/datasources_fromwebbox-150x54.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/datasources_fromwebbox-300x108.png 300w\" sizes=\"auto, (max-width: 702px) 100vw, 702px\" \/><\/a><p id=\"caption-attachment-19659\" class=\"wp-caption-text\">Connecting a Data Source in Power Bi<\/p><\/div>\n<p>You can either load the information by choosing the Load button at an all-time low of the Navigator pane or edit the question before loading information by choosing the Edit button.<br \/>\nThat\u2019s all there&#8217;s to connect to information sources in Power metal Desktop! strive connecting to information from our growing list of information sources, and check back typically &#8211; we have a tendency to still boost this list all the time.<br \/>\nSo, this was all Power BI Data Sources. Hope you like our explanation.<\/p>\n<h2>6. Conclusion<\/h2>\n<p>Hence, in this tutorial, we learned about Power BI Data Sources. We hope you found it interesting. Still, if you have any doubt regarding Power BI Data Sources, feel free to ask in the comment section.<br \/>\nRelated Topic-\u00a0<strong><a href=\"https:\/\/data-flair.training\/blogs\/install-power-bi\/\">How to Download &amp; Install Power BI<\/a><\/strong><br \/>\n<strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/desktop-directquery-data-sources\">For reference<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Objective In this Power BI tutorial, we will learn about Power BI Data Sources and the format which supported by Power BI. In addition, we will discuss Data Sources in Power Metal Desktop&#46;&#46;&#46;<\/p>\n","protected":false},"author":5,"featured_media":19647,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[6003,9257,9342,9665,9853,9887],"class_list":["post-19621","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi","tag-how-to-connect-a-data-source-in-power-bi","tag-online-services-class","tag-other-class","tag-power-bi-data-sources","tag-power-bi-supported-data-sources","tag-power-metal-class"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Power BI Data Sources (Supported) - Connecting Data Source - DataFlair<\/title>\n<meta name=\"description\" content=\"Power Bi Data Sources Supported, Connect a Data Source in Power Bi, File,Database, Online Services, Azure Class, Data Sources in Power Metal Desktop\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/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 (Supported) - Connecting Data Source - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Power Bi Data Sources Supported, Connect a Data Source in Power Bi, File,Database, Online Services, Azure Class, Data Sources in Power Metal Desktop\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-24T04:00:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-09-11T17:40:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-BI-Supported-Data-Sources-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI Data Sources (Supported) - Connecting Data Source - DataFlair","description":"Power Bi Data Sources Supported, Connect a Data Source in Power Bi, File,Database, Online Services, Azure Class, Data Sources in Power Metal Desktop","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:\/\/data-flair.training\/blogs\/power-bi-data-sources\/","og_locale":"en_US","og_type":"article","og_title":"Power BI Data Sources (Supported) - Connecting Data Source - DataFlair","og_description":"Power Bi Data Sources Supported, Connect a Data Source in Power Bi, File,Database, Online Services, Azure Class, Data Sources in Power Metal Desktop","og_url":"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-07-24T04:00:02+00:00","article_modified_time":"2018-09-11T17:40:33+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-BI-Supported-Data-Sources-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Power BI Data Sources (Supported) &#8211; Connecting Data Source","datePublished":"2018-07-24T04:00:02+00:00","dateModified":"2018-09-11T17:40:33+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/"},"wordCount":1368,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-BI-Supported-Data-Sources-01.jpg","keywords":["How to Connect a Data Source in Power Bi","Online Services Class","other class","Power Bi Data Sources","Power Bi Supported Data Sources","Power Metal Class"],"articleSection":["Power BI Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/","url":"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/","name":"Power BI Data Sources (Supported) - Connecting Data Source - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-BI-Supported-Data-Sources-01.jpg","datePublished":"2018-07-24T04:00:02+00:00","dateModified":"2018-09-11T17:40:33+00:00","description":"Power Bi Data Sources Supported, Connect a Data Source in Power Bi, File,Database, Online Services, Azure Class, Data Sources in Power Metal Desktop","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-BI-Supported-Data-Sources-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Power-BI-Supported-Data-Sources-01.jpg","width":1200,"height":628,"caption":"Power Bi Data Sources"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAS Foundation Tools Certifications","item":"https:\/\/data-flair.training\/blogs\/tag\/sas-foundation-tools-certifications\/"},{"@type":"ListItem","position":3,"name":"Power BI Data Sources (Supported) &#8211; Connecting Data Source"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/19621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=19621"}],"version-history":[{"count":3,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/19621\/revisions"}],"predecessor-version":[{"id":32589,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/19621\/revisions\/32589"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/19647"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=19621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=19621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=19621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}