EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Courses
  • All Courses
  • All in One Bundle
  • Login
Home Data Science Data Science Tutorials Power BI learn Power BI Connections

Power BI Connections

Priya Pedamkar
Article byPriya Pedamkar

Updated June 30, 2023

Power BI Connections

Connections in Power BI

There are many ways to connect the data to Power BI. The variety available in Power BI for connecting the data is way more than any tool available in the market. Apart from regular connections, which are Excel, Text, and CSV files, we can use queries, databases, SQL Servers, Cloud, and Websites to get the data. The mentioned platforms are those platforms that are commonly utilized apart from Excel and Text files. All possible connection sources in Power BI have been categorized per their applications. We will see all these connections in this article in detail.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Types of Connections Available in Power BI

Go to the Home menu ribbon to access and see all the connection types available in Power. And under the External Data section, select the Get Data option, highlighted in the screenshot below.

Get Data

Once we click Get Data, we can see the most commonly used Connections in the drop-down list. As we can see, all the common connections we discussed above are Excel, Power BI datasets, Power BI dataflows, SQL Server, Text, Web, etc. can be seen. To get all the connection categories, click More, as shown below.

Power BI Connections - Get Data

We have understood the process. Now we will see the different categories under the More option of Get Data. Once we click on More from Get Data drop-down menu, we will get the complete list of all the connections available in Power, as shown below.

Power BI Connections

  • As we can see, we have all connections listed under ALL categories, irrespective of their type. If we scroll down further, we can see more of them.

Power BI Connections Example 2

As we can see, apart from ALL categories, 6 other categories are specific to their types, which are:

  • File
  • Database
  • Power Platform
  • Azure
  • Online Services
  • Others

Let’s see each one of them one by one.

#1. File

We know commonly used file types such as Excel, Text, and PDF. Here also, if we click on the File tab, we will be able to different file types list under File. Apart from the previously mentioned files, we have XML, JSON, Folder, and SharePoint folders.

Example 1 (File)

#2. Database

We also might have seen or used SQL, MySQL, and MS Access databases. These are the databases that most people have seen or used. Apart from these databases, we have Oracle, IBM, Sybase, PostgreSQL, Teradata, SAP HANA, Impala, Snowflake, Essbase, Amazon Redshift, Exasol, Dremio, Indexima (Beta), Marklogic, etc. types under Database.

Example 2 (Database)

The database tab has all the possible types of Database tool connections available in the market. Such kind of variety is not available in any other BI tool.

#3. Power Platform

By seeing the name Power Platform, we can say this category has all the Power BI databases. Under this category, we have Power BI datasets, Power BI dataflows, Common data services, and Power Platform dataflows.

Example 3 (Power Platform)

#4. Azure

Azure is a kind of cloud database platform. This lets us fetch the data from any Cloud platform into Power BI. The Azure category contains Azure SQL Database, SQL Data Warehouse, Analysis Services Database, Blob/Table Storage, Cosmos DB, HDInsight Spare/HDFS, Azure Data Lake Storage Gen1 and Gen2 (Beta), etc.

Example 4 (Azure)

#5. Online Services

In Power BI, we have a variety of online services and tools by which we can fetch the data. These are Sharepoint, MS Exchange Online, Dynamics 365/NAV, Dynamics 365 Business Central, MS Azure Consumption Insight, Azure DataOps, and Server, Salesforce Objects and Reports, Google Analytics, Adobe Analytics, Facebook, LinkedIn, SweetIQ, Planview Enterprise One, Twilio, tyGraph, Webtrends, Zendesk, Emigo Data Source, Entersolt Business Suite, Industrial App Store, Product Insight, Quick Base, TeamDesk, Workplace Analytics, etc.

Example 5 (Online Services)

#6. Other

In other categories, we have all the left sources of databases that can be used for database purposes. This category includes all programming and analysis languages, such as R, Spark, Python, and Hadoop, which are commonly used. Apart from these, we have Sharepoint List, OData Feed, Active Directory, MS Exchange, OLE DB, Information Grid, Paxata, Roamier, Siteimprove, Survey Monkey, Vena, Workplace Dimensions, Tenforce, Blank Query, etc.

Power BI Connections Example 6

Most of the database types from the Other category are free available.

How to Fetch Data From a Website?

We all have used different tools to get the data. But now we will see how to fetch data from a website. We will use (the imf.org website) to fetch world population data. Or else we can search in Google with “IMF world economic outlook database” and open the first link, click on the By Countries (Country-Level-Data) link, select all the countries, and then choose Population among all the options.

  • Go to the Get Data option from Other categories, and select Web.

Power BI Connections Example 7

  • Copy the link from the browser and paste that here. Click on Ok to proceed.

Power BI Connections Example 8

  • After a few moments, Power BI will fetch the data from that link. Select the sheet which has the data of our users. Then click on Load.

Power BI Connections Example 9

  • The uploaded data is from the selected link under the Data View tab.

Example 10(Data view tab)

Pros of Power BI Connections

  • Power BI Connections has the most variety of sources available with the proper connecting process.
  • Apart from commonly used connection and file sources, the other connection types in Power BI are also connected to Text, Excel, or PDF files.

Things to Remember

  • Despite the vast variety of database sources available in Power BI, we can still not use or link more than 5 sources.
  • Most commonly used database sources are available under the File category.
  • A year or 2 years back, the list of currently added databases was half of the present list. Microsoft is continuously working on adding more and more databases into Power BI.

Recommended Articles

This is a guide to Power BI Connections. Here we discuss the types of Connections Available in Power BI and how to Fetch Data from a Website, along with examples. You may also look at the following articles to learn more –

  1. How to Create a Power BI Bubble Chart?
  2. What is Bullet Chart in Power BI?
  3. Power BI Tooltips | Creating Report Page Tooltips
  4. Power BI Drillthrough | How to Work?
  5. Guide to Power BI Themes
  6. Power BI Parameters | Examples
  7. Power BI Alternatives | Amazing 8
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
All in One Data Science Bundle2000+ Hour of HD Videos | 80 Learning Paths | 400+ Courses | Verifiable Certificate of Completion | Lifetime Access
Financial Analyst Masters Training Program2000+ Hours of HD Videos | 43 Learning Paths | 550+ Courses | Verifiable Certificate of Completion | Lifetime Access
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more