NEW! FREE 45 Minutes Excel VBA Loop Course for Beginners Watch now 

Power BITutorials

Best Ways to Import Data From CSV in Power Query

1 Mins read

Now you know how to import data from an XML file in Power Query. But what if your data source is in the form of a CSV file? There is no need to worry if you have your data inside a CSV file (Comma Separated Values). This is because it’s very easy to import data from CSV into Power Query!

 

Import Data from CSV using Power Query

Nowadays, many times you get data in the comma-delimited format.

Let’s see how to import this data into Power Query.

Step 1: Get data from CSV

To get data from CSV you should have a CSV file containing data saved on your PC. Then, you can easily connect within a few clicks in Power BI as given below-

Home  >  Get Data  >  Text/CSV

GET DATA FROM CSV

Step 2: Link the CSV data into Power Query

Once you click on the connect option in Power BI, it will take you to the directory where you have saved your CSV file. You just have to select the file and click on open as shown below.

CONNECT THE CSV DATA SOURCE TO POWER QUERY

Step 3: Close & Apply

After clicking on the Open option, the selected CSV file gets open in Power Query as shown in below picture. Here, you can view the data and do the required data manipulations. After doing so, click on the Close & Apply button.

CSV DATA SOURCE IN POWER QUERY

You can know more :

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…