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.
To get more data sources, click the More option from the list.
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.
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.
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.
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.
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.
The next option is Other, which has options to connect with any web applications, R Services, Python Scripts and many others.
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.