Data sources for the Power BI

Introduction

In this article, we will learn “How to connect Power BI with difference Data Sources”. With Power BI, we can connect different types of data such like from Excel to Online data.

Connecting Power BI with Different Data Sources

Select Get Data option from the Home Menu in the Ribbon tool. This will list common data sources that we can connect within Power BI.

Fig.1 Get Data from Home Ribbon Tool

To get more data sources, click the More option from the list.

Fig. 2 More Options of Data Sources to Connect

From the left side of the screen, All options will list all type of data sources that we can connect. Under the All option, we can see the data sources are grouped in different types of categories as File, Database, Power Platform, Azure, Online Services and other.

Now lets choose the File option and it will show the list of files that Power BI supports.

Fig.3 List of File Data Sources that Power BI Supports

As a user we can connect to our data source very easily by clicking the Connect button.

Likewise we can connect quickly with any Database by clicking the option Database and it will list a wider list of databases that we can connect with out Power BI.

Fig. 4 Databases that we can connect with Power BI

When connecting with Databases, we should have the proper credentials (User Name and Password) to connect and access the data.

The next potion is Power Platform. Power BI is providing some space, where we can store our data and directly connect with Power BI.

Fig. 5 Power Platform Data sources

Next options in the Get Data option is Microsoft’s Azure. Azure is a cloud platform and all we need is Azure credentials to connect. Any Azure services are listed out and we can easily connect with.

Fig. 6 Azure Data Sources

Next option in the list is Online Services. From is option, we can connect to third party tool as such as Google Analytics, Adobe Analytics and any others. From this window we can connect to Microsoft’s and other third parties tools. We have so many options here to connect with.

Fig. 7 Online Services to connect Third Party tools

The next option is Other, which has options to connect with any web applications, R Services, Python Scripts and many others.

Fig. 8 Other Options in the Get Data List

Conclusion

With all these options we can easily fetch data into the Power BI. Almost all the data sources are available in Power BI, using these we can make Dashboards and Reports easily. In this article we have discussed about the data sources that we can connect with Power BI. In the next article we will discuss “How to connect Data to Power BI “. Please share your feedback in the comment section.

Consider to Read

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

Website Built with WordPress.com.

Up ↑

%d bloggers like this: