Data source

In Power BI, the data you explore comes from a dataset. But in order to have a dataset, you first need to get some data.

A dataset is like the engine in a car. The dataset provides the data, metrics, and information that’s displayed in your Power BI dashboard. Of course your engine, or dataset, needs fuel, and in Power BI, that fuel is data

A car has a fuel tank that provides gas to the engine. Much the same in Power BI, you need a fuel tank that has data you can feed to your dataset. In our case, that fuel tank is a Power BI Desktop file, an Excel workbook file, or a .CSV file.

Once we have a file with some data, we can get it into Power BI as a dataset

Power BI supports many different data sources

Import vs Get Data

Import vs get data in Power BI Step 1

Import vs get data in Power BI Step 2

Import vs get data in Power BI Step 3

Import vs get data in Power BI Step 4

List of data sources

Databases

Import

DirectQuery

Connect Live

See: https://docs.microsoft.com/en-us/power-bi/desktop-data-sources#database-data-sources

Files

In Power BI (Power BI service), you can connect to or import data and reports from three types of files:

In Power BI Desktop (Home > Get data > More…)

Power BI Get data from files