Power BI Data Sources (Supported) – Connecting Data Source

Stay updated with the latest technology trends while you're on the move - Join DataFlair's Telegram Channel

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 are: All Class, File class, Database Class, Online Services Class, Azure Class, and Other Class. At last, we will see How can we Connect a Data Source in Power BI.
So, let’s start Power BI Data Source.

Power Bi Data Sources

Power BI Data Sources (Supported) – Connecting Data Source

2. Power BI Data Sources

Data is at the center of Power atomic number 83. Whenever you are exploring information, making charts and dashboards, asking queries with Q&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.
In this Power BI Data Source Article, we’re getting to check the various kinds of information sources you’ll connect with from the ability atomic number 83 service. Keep in mind, there square measure several different kinds of information sources you’ll get information from, too. However, those may need 1st exploitation Power atomic number 83 Desktop or Excel’s advanced information question and modeling options. We’ll go in a lot of that later. For now, let’s look into the various kinds of information sources you’ll connect with right from your Power atomic number 83 service website.
Do you know How to Create Power BI Dashboard with Example 

3. Data Sources in Power Metal Desktop

With Power metal Desktop, you’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.
To 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:

Power Bi Data Sources

Power BI Data Sources in Power Metal Desktop

Selecting More… from the foremost Common menu displays the Get information window. You’ll conjointly point out the Get information window (and bypass the foremost Common menu) by choosing the Get information icon button directly.

Power Bi Data Sources

Data Sources in Power Metal Desktop

Note – 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.
Let’s explore Power BI Architecture – With Data Security

4. Power BI Data Sources

Data sort are organized within the following categories:

Power Bi Data Sources

Power Bi Data Sources

a. All Class

The All-class includes all information affiliation sorts from all classes.

b. File Class

The File class provides the subsequent information connections:

  • Excel
  • Text/CSV
  • XML
  • JSON
  • Folder
  • SharePoint Folder

The following image shows the Get information window for File.

Power Bi Data Sources

Power BI Data Sources – File Class

c. Database Class

The database class provides the subsequent information connections:

  • SQL Server database
  • Access info
  • SQL Server Analysis Services database
  • Oracle info
  • IBM DB2 info
  • IBM Informix info (Beta)
  • IBM Netezza
  • MySQL info
  • PostgreSQL info
  • Sybase info
  • Teradata info
  • SAP HANA info
  • SAP Business Warehouse Application Server
  • SAP Business Warehouse Message Server (Beta)
  • Amazon Redshift
  • Impala
  • Google BigQuery
  • Snowflake
  • Exasol

Do you know How to Create Workspace in Power BI 
Some info connexions need that you simply modify them by choosing File > choices and settings > 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.
The following image shows the Get information window for info.

Power Bi Data Sources

Power BI Data Sources – Database-Class

d. Power Metal Class

The Power metal class provides the subsequent information connections:

  • Power metal datasets
  • Power metal data pools (beta)

The following image shows the Get information window for Power metal.

Power Bi Data Sources

Power BI Data Sources – Power Metal Class

e. Azure Class

The Azure class provides the subsequent information connections:

  • Azure SQL info
  • Azure SQL information Warehouse
  • Azure Analysis Services info
  • Azure Blob Storage
  • Azure Table Storage
  • Azure Cosmos sound unit (Beta)
  • Azure information Lake Store
  • Azure HDInsight (HDFS)
  • Azure HDInsight Spark (Beta)
  • HDInsight Interactive question (Beta)
  • Azure KustoDB (beta)

Read about Power BI Data Modeling – Creating Calculated Columns
The following image shows the Get information window for Azure.

Power Bi Data Sources

Power BI Data Sources – Azure Class

f. Online Service Class

The Online Services class provides the subsequent information connections:

  • SharePoint online List
  • Microsoft Exchange online
  • Dynamics 365 (online)
  • Dynamics NAV (Beta)
  • Dynamics 365 Business Central
  • Common information Service for Apps(Beta)
  • Common information Service (Beta)
  • Microsoft Azure Consumption Insights (Beta)
  • Visual Studio Team Services (Beta)
  • Salesforce Objects
  • Salesforce Reports
  • Google Analytics
  • Adobe Analytics
  • appFigures (Beta)
  • comScore Digital Analytix (Beta)
  • Dynamics 365 for client Insights (Beta)
  • Data.World – Get Dataset (Beta)
  • Facebook
  • GitHub (Beta)
  • MailChimp (Beta)
  • Marketo (Beta)
  • Mixpanel (Beta)
  • Planview Enterprise One – PRM (Beta)
  • Planview Projectplace (Beta)
  • QuickBooks online (Beta)
  • Smartsheet
  • SparkPost (Beta)
  • Stripe (Beta)
  • SweetIQ (Beta)
  • Planview Enterprise One – CMT (Beta)
  • Twilio (Beta)
  • tyGraph (Beta)
  • Webtrends (Beta)
  • Zendesk (Beta)
  • TeamDesk (Beta)

Let’s Learn about Power BI View Dashboard & Report on Mobile, Tab, PC
The following image shows the Get information window for on-line Services.

Power Bi Data Sources

Power BI Data Sources – Online Service Class

g. Other Class

The Other class provides the subsequent information connections:

  • Vertica (Beta)
  • Web
  • SharePoint List
  • OData Feed
  • Active Directory
  • Microsoft Exchange
  • Hadoop File (HDFS)
  • Spark (Beta)
  • R Script
  • ODBC
  • OLE DB
  • Blank question

The following image shows the Get information window for an alternative.

Power Bi Data Sources

Power BI Data Sources – Other Class

Note – At now, it is not attainable to attach to custom information sources secured victimization Azure Active Directory.

5. How Can We Connect a Data Source in Power BI

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.

Power Bi Data Sources

How can we Connect a Data Source in Power Bi

An affiliation window is displayed, specific to the sort of information affiliation. If credentials are needed, you’ll be prompted to produce them. The subsequent image shows a URL being entered to attach to an internet information supply.

Power Bi Data Sources

Connecting a Data Source in Power Bi

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.

Power Bi Data Sources

Connecting a Data Source in Power Bi

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.
That’s all there’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 – we have a tendency to still boost this list all the time.
So, this was all Power BI Data Sources. Hope you like our explanation.

6. Conclusion

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.
Related Topic- How to Download & Install Power BI
For reference

Leave a Reply

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.