How to Import Data from 4 Data Source Categories — Data Analysis in Power BI — Chapter 2

In comparison with other business intelligence tool, Power BI can connect with 100 different data sources.


In my previous blog, you get an idea about the Power BI tool and its installation process.

Now it’s time to get data from different data sources and import it Power BI. 


Data Source Categories and Connectivity Mode

In comparison with other business intelligence tool, Power BI can connect with 100 different data sources.

There are 6 types of data source categories and 3 types of data connectivity modes.

In the below video, you can get an idea about all these data source categories and data connectivity modes.

Do you want to more about these data connectivity modes and their comparison study? 

Check this below blog

https://arpitatechcorner.com/2021/01/14/how-data-connectivity-modes-are-different-from-each-other-in-power-bi/

Get Data from File Source (CSV)

How you can connect with a file data source like CSV, please have a look at the below short video and get your hands dirty with data.

Get Data from Database (MS SQL Server)

I am sure, you are very excited to know more about how to connect with other data sources. 

In this below short video, I have shown how to connect to one database like MS SQL Server.

Get Data from Online Services (Data World)

You already came to know from the first video, how are all the online services data providers. 

In the below short video, I have shown how you can connect with public data online services like https://data.world/.

It helps to get our project more automated, as every time I don’t need to refresh the data source like file data.

Get Data from Other Data Sources (Website)

I found this connectivity is more interesting. As I don’t need to search for any data, just put the URL and get the data.

In the below short video, you can find out this simple way. 

Conclusion

In this blog, you learn about below things

  1. Data Source Categories and Data Connectivity Modes
  2. How to connect to File Data Sources
  3. Get data from Database
  4. Import data from Online Services
  5. What is the way to connect with other data sources like web

In my next blog, we will learn more in details.

If you have any questions related to this project, please feel free to post your comments.

Please visit my website for other technical resources.

Please like, comment and subscribe to my YouTube channel which you have already seen. 🙂 Keep Learning.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: