In this tutorial, we want to import Data from a CSV file into Power BI. This can be easily done in the Power BI Desktop interface.

Data Source

Our data source is the CSV file student. The file contains the following data:

Power BI Desktop

In the following, we explain step by step how to import the data into Power BI Desktop.

Open Power BI Desktop

First, we open Power BI Desktop.

Get Data

Now, we click on the button “Get data”.

Choose Data Source

We get a selection of different data sources. We choose the data scource “Text/CSV” and click “Connect”.

Connection to Data Source

Now, a new window opens and we have to search the location of the CSV file. In our case, the location is on a local drive. We select the CSV file student.

Select Data

Next, we get a preview of the data. Since we do not want to make any transformations on the data, we click directly on “Load”.

Imported Data

To check if the data has been imported successfully we go to “Table View” on the left side. We can see that the data is there, so everything worked.


Congratulations! Now you are one step closer to become an AI Expert. You have seen that it is very easy to import Data from a CSV file into Power BI. Try it yourself!


Also check out our Instagram page. We appreciate your like or comment. Feel free to share this post with your friends.